[Home] [Help]
1096: 'EXPENSE',PD.expenditure_organization_id,
1097: NULL), --expenditure_organization_id
1098: DECODE(PD.destination_type_code,
1099: 'EXPENSE', PD.award_id), --award_id
1100: ap_invoice_distributions_s.nextval
1101: FROM po_distributions_ap_v PD,
1102: rcv_transactions RT
1103: WHERE PD.line_location_id = x_po_line_location_id
1104: and Pd.line_location_id = RT.po_line_location_id
1392: pd.award_id,
1393: pd.expenditure_type,
1394: pd.expenditure_item_date,
1395: pd.expenditure_organization_id,
1396: ap_invoice_distributions_s.nextval
1397: INTO x_dist_tab(i).po_ccid,
1398: x_dist_tab(i).accrue_on_receipt_flag,
1399: x_dist_tab(i).project_id,
1400: x_dist_tab(i).task_id,
3766: 'EXPENSE', DECODE(pd.accrue_on_receipt_flag,
3767: 'Y', pd.code_combination_id,
3768: aid1.dist_code_combination_id),
3769: pd.variance_account_id),
3770: ap_invoice_distributions_s.nextval
3771: FROM ap_invoice_lines ail,
3772: ap_invoice_distributions aid1,
3773: po_distributions pd,
3774: ap_invoice_distributions aid2
3810: ) amount,
3811: round((x_correction_quantity * pd.quantity_billed)/
3812: p_total_quantity_billed , 15) corrected_quantity,
3813: aid.dist_code_combination_id,
3814: ap_invoice_distributions_s.nextval
3815: FROM ap_invoice_distributions aid,
3816: ap_invoice_lines ail,
3817: po_distributions pd
3818: WHERE ail.invoice_id = x_corrected_invoice_id
3976: FOR i IN nvl(x_corr_dist_tab.first,0) ..nvl(x_corr_dist_tab.last,0) LOOP
3977:
3978: IF (x_corr_dist_tab.exists(i)) THEN
3979:
3980: SELECT ap_invoice_distributions_s.nextval
3981: INTO x_corr_dist_tab(i).invoice_distribution_id
3982: FROM dual ;
3983:
3984: x_corr_dist_tab(i).pa_quantity := x_corr_dist_tab(i).corrected_quantity;