Good Afternoon ,
I am using SQL Developer and Pl/SQL Developer
2 Questions:
1.) Am I Executing the Procedure Correctly using ?
begin
COST_DATA_DISB_COMPL_REPORT(2329204);
end;
I am getting an error when trying to execute a "Procedure" using:
begin
COST_DATA_DISB_COMPL_REPORT( '2329204' );
end;
Also Tried Execute COST_DATA_DISB_COMPL_REPORT; This Did Not Work
2.) How do I call the Procedure from Application ?
Error I'm getting is:
When I Run the SQL Statement Outside of the "Create Or Replace Procedure it Executes and Outputs as I want
With get_debit_credit_ind AS
(
select c_acct_type, c_tran_type,
Case When f\_debit\_credit\_ind IN ('A', 'D')
Then f\_debit\_credit\_ind
Else 'X'
End as m\_debit\_credit\_ind
,
a\_posting
from fdep.detail_postings@fdep_bidb dtlpost
Where c_Job_Piece = '2329204'
-- and c_acct_type IN ('1','2','3','4','5')
and dtlpost.c_object like '47%'
and dtlpost.c_ref_type = 'CL'
and dtlpost.c_part_code = 1
and dtlpost.c_acct_type = 5
)
, get_m_posting AS
(
select d.*
,
CASE
WHEN (c\_acct\_type, m\_debit\_credit\_ind)
IN ( ('1','X')
, ('2','A')
, ('2','D')
, ('3','D')
, ('4','D')
, ('5','A')
, ('5','D')
)
THEN -a\_posting
ELSE a\_posting
END AS m\_posting
FROM get_debit_credit_ind d
)
--,
-- Aggregate_Results As
Select
to\_char(nvl(SUM ( CASE
WHEN c\_tran\_type \<> 'D'
THEN 0
WHEN c\_acct\_type = 5
THEN -m\_posting
ELSE +m\_posting
END
),0),'999,999,990.99') as "Part Const Compl"
--into v_Part_Const_Compl
FROM get_m_posting
;
With get_debit_credit_ind AS
(
select c_acct_type, c_tran_type,
Case When f\_debit\_credit\_ind IN ('A', 'D')
Then f\_debit\_credit\_ind
Else 'X'
End as m\_debit\_credit\_ind
,
a\_posting
from fdep.detail_postings@fdep_bidb dtlpost
Where c_Job_Piece = '2329204'
-- and c_acct_type IN ('1','2','3','4','5')
and dtlpost.c_object like '47%'
and dtlpost.c_ref_type = 'CL'
and dtlpost.c_part_code = 2
and dtlpost.c_acct_type = 5
)
, get_m_posting AS
(
select d.*
,
CASE
WHEN (c\_acct\_type, m\_debit\_credit\_ind)
IN ( ('1','X')
, ('2','A')
, ('2','D')
, ('3','D')
, ('4','D')
, ('5','A')
, ('5','D')
)
THEN -a\_posting
ELSE a\_posting
END AS m\_posting
FROM get_debit_credit_ind d
)
--,
-- Aggregate_Results As
Select
to\_char(nvl(SUM ( CASE
WHEN c\_tran\_type \<> 'D'
THEN 0
WHEN c\_acct\_type = 5
THEN -m\_posting
ELSE +m\_posting
END
),0),'999,999,990.99') as "NonPart Const Compl"
--into v_NonPART_CONST_COMPL
FROM get_m_posting
;
select to_char(nvl(sum(a_disb_amt),0),'999,999,990.99') as "Part Const Disb"
--into v_PART_CONST_DISB
from fdep.pfs_detail_records@fdep_bidb
where c_jpnum = '2329204'
and c_objcd like '4%' -- Const
and c_Partcode In (1,4) -- participating as "Part Const Disb"
and (EXISTS (select null from jbp.fmis5_head_data fmis5 where fmis5.c_jpno = '2329204' )
and c\_fedcode is not null)
OR
(NOT EXISTS (select null from jbp.fmis5\_head\_data fmis5 where fmis5.c\_jpno = '2329204' )
and c\_fedcode is null);
select to_char(nvl(sum(a_disb_amt),0),'999,999,990.99') as "Non Part Const Disb"
--into v_NONPART_CONST_DISB
from fdep.pfs_detail_records@fdep_bidb
where c_jpnum = '2329204'
and c_objcd like '4%' -- Const
and c_Partcode Not In (1,4) -- non participating
and (EXISTS (select null from jbp.fmis5_head_data fmis5 where fmis5.c_jpno = '2329204')
and c\_fedcode is not null)
OR
(NOT EXISTS (select null from jbp.fmis5\_head\_data fmis5 where fmis5.c\_jpno = '2329204')
and c\_fedcode is null)
;
With get_debit_credit_ind AS
(
select c_acct_type, c_tran_type,
Case When f\_debit\_credit\_ind IN ('A', 'D')
Then f\_debit\_credit\_ind
Else 'X'
End as m\_debit\_credit\_ind
,
a\_posting
from odot2.detail_postings_vw dtlpost
where dtlpost.c_Job_Piece = '2329204'
and dtlpost.c_object like '15%'
and dtlpost.c_ref_type = 'CL'
and dtlpost.c_part_code = 2
and dtlpost.c_acct_type = 5
)
, get_m_posting AS
(
select d.*
,
CASE
WHEN (c\_acct\_type, m\_debit\_credit\_ind)
IN ( ('1','X')
, ('2','A')
, ('2','D')
, ('3','D')
, ('4','D')
, ('5','A')
, ('5','D')
)
THEN -a\_posting
ELSE a\_posting
END AS m\_posting
FROM get_debit_credit_ind d
)
--,
-- Aggregate_Results As
Select
to\_char(nvl(SUM ( CASE
WHEN c\_tran\_type \<> 'D'
THEN 0
WHEN c\_acct\_type = 5
THEN -m\_posting
ELSE +m\_posting
END
),0),'999,999,990.99') as "Part Eng Compl"
-- into v_PART_ENG_COMPL
FROM get_m_posting
;
With get_debit_credit_ind AS
(
select c_acct_type, c_tran_type,
Case When f\_debit\_credit\_ind IN ('A', 'D')
Then f\_debit\_credit\_ind
Else 'X'
End as m\_debit\_credit\_ind
,
a\_posting
from odot2.detail_postings_vw dtlpost
where dtlpost.c_Job_Piece = '2329204'
and dtlpost.c_object like '15%'
and dtlpost.c_ref_type = 'CL'
and dtlpost.c_part_code = 1
and dtlpost.c_acct_type = 5
)
, get_m_posting AS
(
select d.*
,
CASE
WHEN (c\_acct\_type, m\_debit\_credit\_ind)
IN ( ('1','X')
, ('2','A')
, ('2','D')
, ('3','D')
, ('4','D')
, ('5','A')
, ('5','D')
)
THEN -a\_posting
ELSE a\_posting
END AS m\_posting
FROM get_debit_credit_ind d
)
--,
-- Aggregate_Results As
Select
to\_char(nvl(SUM ( CASE
WHEN c\_tran\_type \<> 'D'
THEN 0
WHEN c\_acct\_type = 5
THEN -m\_posting
ELSE +m\_posting
END
),0),'999,999,990.99') as "NonPart Eng Compl"
--Into v_NONPART_ENG_COMPL
FROM get_m_posting
;
select to_char(nvl(sum(a_disb_amt),0),'999,999,990.99') as "Part Eng Disb"
--into v_PART_ENG_DISB
from fdep.pfs_detail_records@fdep_bidb
where c_jpnum = '2329204'
and c_objcd Not like '4%' -- Eng
and c_Partcode In (1,4) -- participating
and (EXISTS (select null from jbp.fmis5_head_data fmis5 where fmis5.c_jpno = '2329204')
and c\_fedcode is not null)
OR
(NOT EXISTS (select null from jbp.fmis5\_head\_data fmis5 where fmis5.c\_jpno = '2329204')
and c\_fedcode is null)
;
select to_char(nvl(sum(a_disb_amt),0),'999,999,990.99') as "NonPart Eng Disb"
--into v_NONPART_ENG_DISB
from fdep.pfs_detail_records@fdep_bidb
where c_jpnum = '2329204'
and c_objcd Not like '4%' -- Eng
and c_Partcode Not In (1,4) -- non participating
and (EXISTS (select null from jbp.fmis5_head_data fmis5 where fmis5.c_jpno = '2329204')
and c\_fedcode is not null)
OR
(NOT EXISTS (select null from jbp.fmis5\_head\_data fmis5 where fmis5.c\_jpno = '2329204')
and c\_fedcode is null)
;
select to_char(nvl(sum(a_fed_amt),0),'999,999,990.99') as "Fed Participation Construction"
--into v_FMIS_CONST
from jbp.fmis5_detail_data dd
where c_jpno = '2329204'
and c\_imprv\_type != 17
and c\_mod\_no =
(select max(c\_mod\_no)
from jbp.fmis5\_detail\_data dd1
where dd.c\_jpno = dd1.c\_jpno and dd1.c\_mod\_no \< 999)
;
--FMIS5 Detail Data Engineering Improvement Type = 17
select to_char(nvl(sum(a_fed_amt),0),'999,999,990.99') as "Fed Participation Eng"
--into v_FMIS_ENG
from jbp.fmis5_detail_data dd
where c_jpno = '2329204'
and c\_imprv\_type = 17
and c\_mod\_no =
(select max(c\_mod\_no)
from jbp.fmis5\_detail\_data dd1
where dd.c\_jpno = dd1.c\_jpno and dd1.c\_mod\_no \< 999)
;
Results of above (Each Tab is correct as far as the output number)
Here is the "Procedure"
create or replace procedure "COST_DATA_DISB_COMPL_REPORT" (Job_Piece IN Varchar2)
AS
v_Part_Const_Compl Number(13,2);
v_NonPART_CONST_COMPL Number(13,2);
v_PART_CONST_DISB Number(13,2);
v_NONPART_CONST_DISB Number(13,2);
v_PART_ENG_COMPL Number(13,2);
v_NONPART_ENG_COMPL Number(13,2);
v_PART_ENG_DISB Number(13,2);
v_NonPART_ENG_DISB Number(13,2);
v_FMIS_CONST Number(13,2);
v_FMIS_ENG Number(13,2);
Begin
With get_debit_credit_ind AS
(
select c_acct_type, c_tran_type,
Case When f\_debit\_credit\_ind IN ('A', 'D')
Then f\_debit\_credit\_ind
Else 'X'
End as m\_debit\_credit\_ind
,
a\_posting
from fdep.detail_postings@fdep_bidb dtlpost
Where c_job_piece = Job_Piece
-- and c_acct_type IN ('1','2','3','4','5')
and dtlpost.c_object like '47%'
and dtlpost.c_ref_type = 'CL'
and dtlpost.c_part_code = 1
and dtlpost.c_acct_type = 5
)
, get_m_posting AS
(
select d.*
,
CASE
WHEN (c\_acct\_type, m\_debit\_credit\_ind)
IN ( ('1','X')
, ('2','A')
, ('2','D')
, ('3','D')
, ('4','D')
, ('5','A')
, ('5','D')
)
THEN -a\_posting
ELSE a\_posting
END AS m\_posting
FROM get_debit_credit_ind d
)
--,
-- Aggregate_Results As
Select
to\_char(nvl(SUM ( CASE
WHEN c\_tran\_type \<> 'D'
THEN 0
WHEN c\_acct\_type = 5
THEN -m\_posting
ELSE +m\_posting
END
),0),'999,999,990.99') as "Part Const Compl"
into v_Part_Const_Compl
FROM get_m_posting
;
With get_debit_credit_ind AS
(
select c_acct_type, c_tran_type,
Case When f\_debit\_credit\_ind IN ('A', 'D')
Then f\_debit\_credit\_ind
Else 'X'
End as m\_debit\_credit\_ind
,
a\_posting
from fdep.detail_postings@fdep_bidb dtlpost
Where c_job_piece = Job_Piece
-- and c_acct_type IN ('1','2','3','4','5')
and dtlpost.c_object like '47%'
and dtlpost.c_ref_type = 'CL'
and dtlpost.c_part_code = 2
and dtlpost.c_acct_type = 5
)
, get_m_posting AS
(
select d.*
,
CASE
WHEN (c\_acct\_type, m\_debit\_credit\_ind)
IN ( ('1','X')
, ('2','A')
, ('2','D')
, ('3','D')
, ('4','D')
, ('5','A')
, ('5','D')
)
THEN -a\_posting
ELSE a\_posting
END AS m\_posting
FROM get_debit_credit_ind d
)
--,
-- Aggregate_Results As
Select
to\_char(nvl(SUM ( CASE
WHEN c\_tran\_type \<> 'D'
THEN 0
WHEN c\_acct\_type = 5
THEN -m\_posting
ELSE +m\_posting
END
),0),'999,999,990.99') as "NonPart Const Compl"
into v_NonPART_CONST_COMPL
FROM get_m_posting
;
select to_char(nvl(sum(a_disb_amt),0),'999,999,990.99') as "Part Const Disb"
into v_PART_CONST_DISB
from fdep.pfs_detail_records@fdep_bidb
where c_jpnum = Job_Piece
and c_objcd like '4%' -- Const
and c_Partcode In (1,4) -- participating as "Part Const Disb"
and (EXISTS (select null from jbp.fmis5_head_data fmis5 where fmis5.c_jpno = Job_Piece)
and c\_fedcode is not null)
OR
(NOT EXISTS (select null from jbp.fmis5\_head\_data fmis5 where fmis5.c\_jpno = Job\_Piece)
and c\_fedcode is null);
select to_char(nvl(sum(a_disb_amt),0),'999,999,990.99') as "Non Part Const Disb"
into v_NONPART_CONST_DISB
from fdep.pfs_detail_records@fdep_bidb
where c_jpnum = Job_Piece
and c_objcd like '4%' -- Const
and c_Partcode Not In (1,4) -- non participating
and (EXISTS (select null from jbp.fmis5_head_data fmis5 where fmis5.c_jpno = Job_Piece)
and c\_fedcode is not null)
OR
(NOT EXISTS (select null from jbp.fmis5\_head\_data fmis5 where fmis5.c\_jpno = Job\_Piece)
and c\_fedcode is null)
;
With get_debit_credit_ind AS
(
select c_acct_type, c_tran_type,
Case When f\_debit\_credit\_ind IN ('A', 'D')
Then f\_debit\_credit\_ind
Else 'X'
End as m\_debit\_credit\_ind
,
a\_posting
from odot2.detail_postings_vw dtlpost
where dtlpost.c_job_piece = Job_Piece
and dtlpost.c_object like '15%'
and dtlpost.c_ref_type = 'CL'
and dtlpost.c_part_code = 2
and dtlpost.c_acct_type = 5
)
, get_m_posting AS
(
select d.*
,
CASE
WHEN (c\_acct\_type, m\_debit\_credit\_ind)
IN ( ('1','X')
, ('2','A')
, ('2','D')
, ('3','D')
, ('4','D')
, ('5','A')
, ('5','D')
)
THEN -a\_posting
ELSE a\_posting
END AS m\_posting
FROM get_debit_credit_ind d
)
--,
-- Aggregate_Results As
Select
to\_char(nvl(SUM ( CASE
WHEN c\_tran\_type \<> 'D'
THEN 0
WHEN c\_acct\_type = 5
THEN -m\_posting
ELSE +m\_posting
END
),0),'999,999,990.99') as "Part Eng Compl"
into v_PART_ENG_COMPL
FROM get_m_posting
;
With get_debit_credit_ind AS
(
select c_acct_type, c_tran_type,
Case When f\_debit\_credit\_ind IN ('A', 'D')
Then f\_debit\_credit\_ind
Else 'X'
End as m\_debit\_credit\_ind
,
a\_posting
from odot2.detail_postings_vw dtlpost
where dtlpost.c_job_piece = Job_Piece
and dtlpost.c_object like '15%'
and dtlpost.c_ref_type = 'CL'
and dtlpost.c_part_code = 1
and dtlpost.c_acct_type = 5
)
, get_m_posting AS
(
select d.*
,
CASE
WHEN (c\_acct\_type, m\_debit\_credit\_ind)
IN ( ('1','X')
, ('2','A')
, ('2','D')
, ('3','D')
, ('4','D')
, ('5','A')
, ('5','D')
)
THEN -a\_posting
ELSE a\_posting
END AS m\_posting
FROM get_debit_credit_ind d
)
--,
-- Aggregate_Results As
Select
to\_char(nvl(SUM ( CASE
WHEN c\_tran\_type \<> 'D'
THEN 0
WHEN c\_acct\_type = 5
THEN -m\_posting
ELSE +m\_posting
END
),0),'999,999,990.99') as "NonPart Eng Compl"
Into v_NONPART_ENG_COMPL
FROM get_m_posting
;
select to_char(nvl(sum(a_disb_amt),0),'999,999,990.99') as "Part Eng Disb"
into v_PART_ENG_DISB
from fdep.pfs_detail_records@fdep_bidb
where c_jpnum = Job_Piece
and c_objcd Not like '4%' -- Eng
and c_Partcode In (1,4) -- participating
and (EXISTS (select null from jbp.fmis5_head_data fmis5 where fmis5.c_jpno = Job_Piece)
and c\_fedcode is not null)
OR
(NOT EXISTS (select null from jbp.fmis5\_head\_data fmis5 where fmis5.c\_jpno = Job\_Piece)
and c\_fedcode is null)
;
select to_char(nvl(sum(a_disb_amt),0),'999,999,990.99') as "NonPart Eng Disb"
into v_NONPART_ENG_DISB
from fdep.pfs_detail_records@fdep_bidb
where c_jpnum = Job_Piece
and c_objcd Not like '4%' -- Eng
and c_Partcode Not In (1,4) -- non participating
and (EXISTS (select null from jbp.fmis5_head_data fmis5 where fmis5.c_jpno = Job_Piece)
and c\_fedcode is not null)
OR
(NOT EXISTS (select null from jbp.fmis5\_head\_data fmis5 where fmis5.c\_jpno = Job\_Piece)
and c\_fedcode is null)
;
select to_char(nvl(sum(a_fed_amt),0),'999,999,990.99') as "Fed Participation Construction"
into v_FMIS_CONST
from jbp.fmis5_detail_data dd
where c_jpno = Job_Piece
and c\_imprv\_type != 17
and c\_mod\_no =
(select max(c\_mod\_no)
from jbp.fmis5\_detail\_data dd1
where dd.c\_jpno = dd1.c\_jpno and dd1.c\_mod\_no \< 999)
;
--FMIS5 Detail Data Engineering Improvement Type = 17
select to_char(nvl(sum(a_fed_amt),0),'999,999,990.99') as "Fed Participation Eng"
into v_FMIS_ENG
from jbp.fmis5_detail_data dd
where c_jpno = Job_Piece
and c\_imprv\_type = 17
and c\_mod\_no =
(select max(c\_mod\_no)
from jbp.fmis5\_detail\_data dd1
where dd.c\_jpno = dd1.c\_jpno and dd1.c\_mod\_no \< 999)
;
End COST_DATA_DISB_COMPL_REPORT;
Here is the "Error Stack" from PL/SQL Developer
Here is the Create Table and Insert Statements that the "Procedure" is based on
CREATE TABLE DETAIL_POSTINGS
(
C_FUND VARCHAR2(4) NOT NULL ENABLE,
C_ACCOUNT VARCHAR2(6) NOT NULL ENABLE,
D_POSTING DATE,
C_ACCT_TYPE VARCHAR2(1) NOT NULL ENABLE,
C_TRAN_TYPE VARCHAR2(1) NOT NULL ENABLE,
C_REF_TYPE VARCHAR2(2) NOT NULL ENABLE,
C_REF_NO VARCHAR2(10) NOT NULL ENABLE,
A_POSTING NUMBER(11,2) NOT NULL ENABLE,
F_DEBIT_CREDIT_IND VARCHAR2(1) NOT NULL ENABLE,
C_PART_CODE VARCHAR2(1),
C_JOB_PIECE VARCHAR2(7),
T_OSF_FY VARCHAR2(4),
C_OBJECT VARCHAR2(6)
);
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','201000',to_date('02-MAR-15','DD-MON-RR'),'1','D','JV','6424001',19103511,'D','1','2714504',null,'000811');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('02-MAR-15','DD-MON-RR'),'5','A','JV','6422003',20029682.58,'C','1','2714504','15','000810');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('02-MAR-15','DD-MON-RR'),'5','E','PO','100633',20029682.58,'D','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','201000',to_date('24-MAR-15','DD-MON-RR'),'1','D','JV','7133014',193.82,'C','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('24-MAR-15','DD-MON-RR'),'1','D','JV','7133015',193.82,'D','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('21-APR-15','DD-MON-RR'),'1','D','JV','7900015',6951.45,'C','1','2714504',null,'000816');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('08-APR-15','DD-MON-RR'),'5','A','JV','7523003',259195.9,'C','1','2714504','15','000810');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('01-APR-15','DD-MON-RR'),'1','D','JV','7268010',193.82,'C','1','2714504',null,'000816');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('10-APR-15','DD-MON-RR'),'5','E','PO','Y45744',259195.9,'D','1','2714504','15','152400');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','201000',to_date('08-APR-15','DD-MON-RR'),'1','D','JV','7554020',1615.72,'C','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('08-APR-15','DD-MON-RR'),'1','D','JV','7554021',1615.72,'D','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('17-APR-15','DD-MON-RR'),'5','A','JV','7793003',42676.75,'C','1','2714504','15','000810');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','201000',to_date('14-APR-15','DD-MON-RR'),'1','D','JV','7702026',6951.45,'C','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('14-APR-15','DD-MON-RR'),'5','D','CL','1599338001',1083664.91,'D','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('14-APR-15','DD-MON-RR'),'5','E','CL','1599338001',1083664.91,'C','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('14-APR-15','DD-MON-RR'),'1','D','JV','7699013',1615.72,'C','1','2714504',null,'000816');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('14-APR-15','DD-MON-RR'),'1','D','JV','7702027',6951.45,'D','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('20-APR-15','DD-MON-RR'),'5','E','PO','Y45802',42676.75,'D','1','2714504','15','152400');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('07-MAY-15','DD-MON-RR'),'5','D','CL','1599371801',1266194.24,'D','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('28-APR-15','DD-MON-RR'),'5','D','CL','1599355501',1295529.18,'D','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('28-APR-15','DD-MON-RR'),'5','E','CL','1599355501',1295529.18,'C','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('07-MAY-15','DD-MON-RR'),'5','E','CL','1599371801',1266194.24,'C','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('26-MAY-15','DD-MON-RR'),'5','D','CL','1599390601',1450299.97,'D','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('26-MAY-15','DD-MON-RR'),'5','E','CL','1599390601',1450299.97,'C','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('15-JUN-15','DD-MON-RR'),'5','D','CL','1599423901',1138660.83,'D','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('15-JUN-15','DD-MON-RR'),'5','E','CL','1599423901',1138660.83,'C','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','201000',to_date('01-JUL-15','DD-MON-RR'),'1','D','JV','0005008',6912394.82,'C','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('08-JUN-15','DD-MON-RR'),'5','D','CL','1599410101',1334429.4,'D','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('08-JUN-15','DD-MON-RR'),'5','E','CL','1599410101',1334429.4,'C','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('01-JUL-15','DD-MON-RR'),'1','D','JV','0005009',6912394.82,'D','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','201000',to_date('07-JUL-15','DD-MON-RR'),'1','D','JV','0073092',12533.82,'C','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','201000',to_date('28-JUL-15','DD-MON-RR'),'1','D','JV','0787070',1122269.92,'C','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('07-JUL-15','DD-MON-RR'),'1','D','JV','0071005',6912394.82,'C','1','2714504',null,'000816');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('07-JUL-15','DD-MON-RR'),'1','D','JV','0073093',12533.82,'D','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','201000',to_date('21-JUL-15','DD-MON-RR'),'1','D','JV','0320120',7815.35,'C','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('21-JUL-15','DD-MON-RR'),'1','D','JV','0317047',1480432.93,'C','1','2714504',null,'000816');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','201000',to_date('14-JUL-15','DD-MON-RR'),'1','D','JV','0138068',1480432.93,'C','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('23-JUL-15','DD-MON-RR'),'5','D','CL','1699035201',1237752.2,'D','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('23-JUL-15','DD-MON-RR'),'5','E','CL','1699035201',1237752.2,'C','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('21-JUL-15','DD-MON-RR'),'1','D','JV','0320121',7815.35,'D','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('10-JUL-15','DD-MON-RR'),'5','D','CL','1699019501',1632770.42,'D','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','400800',to_date('10-JUL-15','DD-MON-RR'),'5','E','CL','1699019501',1632770.42,'C','1','2714504','15','471100');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('15-JUL-15','DD-MON-RR'),'1','D','JV','0216047',12533.82,'C','1','2714504',null,'000816');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('14-JUL-15','DD-MON-RR'),'1','D','JV','0138069',1480432.93,'D','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('03-AUG-15','DD-MON-RR'),'5','D','CL','1693857001',21939.42,'D','1','2714504','15','152400');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('03-AUG-15','DD-MON-RR'),'5','D','CL','1693857401',1140.46,'D','1','2714504','15','152400');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('03-AUG-15','DD-MON-RR'),'5','D','CL','1693868301',1060.88,'D','1','2714504','15','152400');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('03-AUG-15','DD-MON-RR'),'5','E','CL','1693857001',21939.42,'C','1','2714504','15','152400');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('03-AUG-15','DD-MON-RR'),'5','E','CL','1693857401',1140.46,'C','1','2714504','15','152400');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('03-AUG-15','DD-MON-RR'),'5','E','CL','1693868301',1060.88,'C','1','2714504','15','152400');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('28-JUL-15','DD-MON-RR'),'1','D','JV','0784065',7815.35,'C','1','2714504',null,'000816');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','201000',to_date('04-AUG-15','DD-MON-RR'),'1','D','JV','1118154',37348.25,'C','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('04-AUG-15','DD-MON-RR'),'1','D','JV','1115036',1122269.92,'C','1','2714504',null,'000816');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('28-JUL-15','DD-MON-RR'),'1','D','JV','0787071',1122269.92,'D','1','2714504',null,'000817');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('07-AUG-15','DD-MON-RR'),'5','D','CL','1693881101',19982.4,'D','1','2714504','15','152400');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('07-AUG-15','DD-MON-RR'),'5','E','CL','1693881101',19982.4,'C','1','2714504','15','152400');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('29-JUL-15','DD-MON-RR'),'5','D','CL','1693849201',17862.56,'D','1','2714504','15','152400');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('29-JUL-15','DD-MON-RR'),'5','D','CL','1693849301',18855.67,'D','1','2714504','15','152400');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('29-JUL-15','DD-MON-RR'),'5','E','CL','1693849201',17862.56,'C','1','2714504','15','152400');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('310H','401800',to_date('29-JUL-15','DD-MON-RR'),'5','E','CL','1693849301',18855.67,'C','1','2714504','15','152400');
Insert into DETAIL_POSTINGS (C_FUND,C_ACCOUNT,D_POSTING,C_ACCT_TYPE,C_TRAN_TYPE,C_REF_TYPE,C_REF_NO,A_POSTING,F_DEBIT_CREDIT_IND,C_PART_CODE,C_JOB_PIECE,T_OSF_FY,C_OBJECT) values ('340C','202000',to_date('04-AUG-15','DD-MON-RR'),'1','D','JV','1118155',37348.25,'D','1','2714504',null,'000817');
Please Let me know if there is anything else needed to Solve
Thank You,
DSteele41