APPS.AP_ETAX_SERVICES_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 6320: FROM po_distributions_all pd

6316: IF l_inv_line_list(i).po_line_location_id IS NOT NULL THEN
6317:
6318: SELECT pd.code_combination_id
6319: INTO l_default_ccid
6320: FROM po_distributions_all pd
6321: WHERE pd.line_location_id = l_inv_line_list(i).po_line_location_id
6322: AND rownum = 1;
6323:
6324: l_inv_line_list(i).default_dist_ccid:=l_default_ccid;

Line 6335: FROM po_distributions_all pd

6331: ELSIF l_inv_line_list(i).po_distribution_id IS NOT NULL THEN
6332:
6333: SELECT pd.code_combination_id
6334: INTO l_default_ccid
6335: FROM po_distributions_all pd
6336: WHERE pd.line_location_id =
6337: (SELECT pod.line_location_id
6338: FROM po_distributions_all pod
6339: WHERE po_distribution_id = l_inv_line_list(i).po_distribution_id)

Line 6338: FROM po_distributions_all pod

6334: INTO l_default_ccid
6335: FROM po_distributions_all pd
6336: WHERE pd.line_location_id =
6337: (SELECT pod.line_location_id
6338: FROM po_distributions_all pod
6339: WHERE po_distribution_id = l_inv_line_list(i).po_distribution_id)
6340: AND rownum = 1;
6341:
6342: l_inv_line_list(i).default_dist_ccid:=l_default_ccid;

Line 6353: FROM po_distributions_all pd

6349: ELSIF l_inv_line_list(i).rcv_shipment_line_id IS NOT NULL THEN
6350:
6351: SELECT pd.code_combination_id
6352: INTO l_default_ccid
6353: FROM po_distributions_all pd
6354: WHERE pd.line_location_id =
6355: (SELECT rcv.po_line_location_id
6356: FROM rcv_shipment_lines rcv
6357: WHERE rcv.shipment_line_id = l_inv_line_list(i).rcv_shipment_line_id)

Line 6371: FROM po_distributions_all pd

6367: ELSIF l_inv_line_list(i).rcv_transaction_id IS NOT NULL THEN
6368:
6369: SELECT pd.code_combination_id
6370: INTO l_default_ccid
6371: FROM po_distributions_all pd
6372: WHERE pd.line_location_id =
6373: (SELECT rcv.po_line_location_id
6374: FROM rcv_transactions rcv
6375: WHERE rcv.transaction_id = l_inv_line_list(i).rcv_transaction_id)

Line 12875: po_distributions_all PD,

12871: pl.unit_meas_lookup_code po_uom,
12872: D.matched_uom_lookup_code rcv_uom,
12873: rsl.item_id rcv_item_id
12874: FROM ap_invoice_distributions_all D,
12875: po_distributions_all PD,
12876: po_lines_all PL,
12877: po_line_locations_all PLL,
12878: rcv_transactions RTXN,
12879: rcv_shipment_lines RSL