DBA Data[Home] [Help]

APPS.AP_MATCHING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_S

Line 1090: ap_invoice_distributions_s.nextval

1086: 'EXPENSE',PD.expenditure_organization_id,
1087: NULL), --expenditure_organization_id
1088: DECODE(PD.destination_type_code,
1089: 'EXPENSE', PD.award_id), --award_id
1090: ap_invoice_distributions_s.nextval
1091: FROM po_distributions_ap_v PD
1092: WHERE line_location_id = x_po_line_location_id;
1093:
1094:

Line 1239: ap_invoice_distributions_s.nextval

1235: award_id,
1236: expenditure_type,
1237: expenditure_item_date,
1238: expenditure_organization_id,
1239: ap_invoice_distributions_s.nextval
1240: INTO x_dist_tab(i).accrue_on_receipt_flag,
1241: x_dist_tab(i).po_ccid,
1242: x_dist_tab(i).project_id,
1243: x_dist_tab(i).task_id,

Line 3521: ap_invoice_distributions_s.nextval

3517: 'EXPENSE', DECODE(pd.accrue_on_receipt_flag,
3518: 'Y', pd.code_combination_id,
3519: aid.dist_code_combination_id),
3520: pd.variance_account_id),
3521: ap_invoice_distributions_s.nextval
3522: FROM ap_invoice_lines ail,
3523: ap_invoice_distributions aid,
3524: po_distributions pd
3525: WHERE ail.invoice_id = x_corrected_invoice_id

Line 3560: ap_invoice_distributions_s.nextval

3556: ) amount,
3557: round((x_correction_quantity * decode(pd.distribution_type,'PREPAYMENT',nvl(pd.quantity_financed,0),nvl(pd.quantity_billed,0)))/
3558: p_total_quantity_billed , 15) corrected_quantity,
3559: aid.dist_code_combination_id,
3560: ap_invoice_distributions_s.nextval
3561: FROM ap_invoice_distributions aid,
3562: ap_invoice_lines ail,
3563: po_distributions pd
3564: WHERE ail.invoice_id = x_corrected_invoice_id

Line 3732: SELECT ap_invoice_distributions_s.nextval

3728: FOR i IN nvl(x_corr_dist_tab.first,0) ..nvl(x_corr_dist_tab.last,0) LOOP
3729:
3730: IF (x_corr_dist_tab.exists(i)) THEN
3731:
3732: SELECT ap_invoice_distributions_s.nextval
3733: INTO x_corr_dist_tab(i).invoice_distribution_id
3734: FROM DUAL;
3735:
3736: x_corr_dist_tab(i).pa_quantity := x_corr_dist_tab(i).corrected_quantity;