[Home] [Help]
505: AND line_number = p_invoice_line_number;
506:
507: l_invoice_line_rec ap_invoice_lines%ROWTYPE;
508: l_match_mode VARCHAR2(8);
509: l_index po_distributions_all.po_distribution_id%TYPE;
510: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
511: l_corr_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%TYPE;
512: l_dist_tab ap_matching_pkg.dist_tab_type;
513: l_othr_chrg_tab ap_othr_chrg_match_pkg.othr_chrg_match_tabtype;
1142: decode(pll.matching_basis,'QUANTITY',sum(nvl(aid.quantity_invoiced,0))),
1143: decode(pll.matching_basis,'AMOUNT',sum(nvl(aid.amount,0))),
1144: pll.matching_basis
1145: from ap_invoice_distributions aid,
1146: po_distributions_all pd,
1147: po_line_locations pll
1148: where pll.line_location_id = p_po_line_location_id
1149: and pll.shipment_type <> 'PREPAYMENT'
1150: and aid.po_distribution_id = pd.po_distribution_id
2481: Begin
2482:
2483: SELECT count(*)
2484: INTO P_num_rect_po_dists
2485: FROM po_distributions_all pod,
2486: rcv_transactions rt
2487: WHERE rt.transaction_id =P_rcv_transaction_id
2488: and rt.po_line_location_id = pod.line_location_id
2489: and (rt.po_distribution_id is null
2535: FROM po_distributions
2536: WHERE line_location_id = p_line_location_id
2537: AND project_id IS NOT NULL ;
2538:
2539: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE ;
2540: l_project_id po_distributions_all.project_id%TYPE ;
2541: l_exp_item_date DATE ;
2542: l_is_date_valid VARCHAR2(1) := 'Y' ;
2543: l_pa_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := NULL ;
2536: WHERE line_location_id = p_line_location_id
2537: AND project_id IS NOT NULL ;
2538:
2539: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE ;
2540: l_project_id po_distributions_all.project_id%TYPE ;
2541: l_exp_item_date DATE ;
2542: l_is_date_valid VARCHAR2(1) := 'Y' ;
2543: l_pa_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := NULL ;
2544: l_token_value1 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE; --Bug 14236129 Modified Bug 16089519