[Home] [Help]
2275: G_dflt_tax_class_code,
2276: G_PAY_AWT_GROUP_ID --bug 9689194
2277: FROM PO_DISTRIBUTIONS_AP_V PD,
2278: MTL_SYSTEM_ITEMS MSI,
2279: PO_AP_RECEIPT_MATCH_V RCV,
2280: RCV_SHIPMENT_LINES RSL,
2281: RCV_TRANSACTIONS RT --7015553
2282: WHERE RCV.RCV_TRANSACTION_ID = X_RCV_TRANSACTION_ID
2283: AND RCV.PO_LINE_LOCATION_ID = PD.LINE_LOCATION_ID
2969: ,'N' --rcv_charge_addition_flag
2970: ,x_dist_tab(i).pay_awt_group_id --pay_awt_group_id --bug 9689194
2971: FROM po_distributions_ap_v pd,
2972: ap_invoice_lines ail,
2973: po_ap_receipt_match_v rcv,
2974: gl_code_combinations gcc
2975: WHERE ail.invoice_id = x_invoice_id
2976: AND ail.line_number = x_invoice_line_number
2977: AND ail.po_line_location_id = pd.line_location_id