APPS.AP_ETAX_SERVICES_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 7533: FROM po_distributions_all pd

7529: IF l_inv_line_list(i).po_line_location_id IS NOT NULL THEN
7530:
7531: SELECT pd.code_combination_id
7532: INTO l_default_ccid
7533: FROM po_distributions_all pd
7534: WHERE pd.line_location_id = l_inv_line_list(i).po_line_location_id
7535: AND rownum = 1;
7536:
7537: /* Bug 8230574

Line 7567: FROM po_distributions_all pd

7563: ELSIF l_inv_line_list(i).po_distribution_id IS NOT NULL THEN
7564:
7565: SELECT pd.code_combination_id
7566: INTO l_default_ccid
7567: FROM po_distributions_all pd
7568: WHERE pd.line_location_id =
7569: (SELECT pod.line_location_id
7570: FROM po_distributions_all pod
7571: WHERE po_distribution_id = l_inv_line_list(i).po_distribution_id)

Line 7570: FROM po_distributions_all pod

7566: INTO l_default_ccid
7567: FROM po_distributions_all pd
7568: WHERE pd.line_location_id =
7569: (SELECT pod.line_location_id
7570: FROM po_distributions_all pod
7571: WHERE po_distribution_id = l_inv_line_list(i).po_distribution_id)
7572: AND rownum = 1;
7573:
7574: /* Bug 8230574

Line 7604: FROM po_distributions_all pd

7600: ELSIF l_inv_line_list(i).rcv_shipment_line_id IS NOT NULL THEN
7601:
7602: SELECT pd.code_combination_id
7603: INTO l_default_ccid
7604: FROM po_distributions_all pd
7605: WHERE pd.line_location_id =
7606: (SELECT rcv.po_line_location_id
7607: FROM rcv_shipment_lines rcv
7608: WHERE rcv.shipment_line_id = l_inv_line_list(i).rcv_shipment_line_id)

Line 7641: FROM po_distributions_all pd

7637: ELSIF l_inv_line_list(i).rcv_transaction_id IS NOT NULL THEN
7638:
7639: SELECT pd.code_combination_id
7640: INTO l_default_ccid
7641: FROM po_distributions_all pd
7642: WHERE pd.line_location_id =
7643: (SELECT rcv.po_line_location_id
7644: FROM rcv_transactions rcv
7645: WHERE rcv.transaction_id = l_inv_line_list(i).rcv_transaction_id)

Line 8538: FROM po_distributions_all pd

8534: IF P_Inv_Line_List(i).po_line_location_id IS NOT NULL THEN
8535:
8536: SELECT pd.code_combination_id
8537: INTO l_default_ccid
8538: FROM po_distributions_all pd
8539: WHERE pd.line_location_id = P_Inv_Line_List(i).po_line_location_id
8540: AND rownum = 1;
8541:
8542: /* Bug 8230574

Line 8574: FROM po_distributions_all pd

8570: ELSIF P_Inv_Line_List(i).po_distribution_id IS NOT NULL THEN
8571:
8572: SELECT pd.code_combination_id
8573: INTO l_default_ccid
8574: FROM po_distributions_all pd
8575: WHERE pd.line_location_id =
8576: (SELECT pod.line_location_id
8577: FROM po_distributions_all pod
8578: WHERE po_distribution_id = P_Inv_Line_List(i).po_distribution_id)

Line 8577: FROM po_distributions_all pod

8573: INTO l_default_ccid
8574: FROM po_distributions_all pd
8575: WHERE pd.line_location_id =
8576: (SELECT pod.line_location_id
8577: FROM po_distributions_all pod
8578: WHERE po_distribution_id = P_Inv_Line_List(i).po_distribution_id)
8579: AND rownum = 1;
8580:
8581: /* Bug 8230574

Line 8611: FROM po_distributions_all pd

8607: ELSIF P_Inv_Line_List(i).rcv_shipment_line_id IS NOT NULL THEN
8608:
8609: SELECT pd.code_combination_id
8610: INTO l_default_ccid
8611: FROM po_distributions_all pd
8612: WHERE pd.line_location_id =
8613: (SELECT rcv.po_line_location_id
8614: FROM rcv_shipment_lines rcv
8615: WHERE rcv.shipment_line_id = P_Inv_Line_List(i).rcv_shipment_line_id)

Line 8648: FROM po_distributions_all pd

8644: ELSIF P_Inv_Line_List(i).rcv_transaction_id IS NOT NULL THEN
8645:
8646: SELECT pd.code_combination_id
8647: INTO l_default_ccid
8648: FROM po_distributions_all pd
8649: WHERE pd.line_location_id =
8650: (SELECT rcv.po_line_location_id
8651: FROM rcv_transactions rcv
8652: WHERE rcv.transaction_id = P_Inv_Line_List(i).rcv_transaction_id)

Line 16494: po_distributions_all PD,

16490: pl.unit_meas_lookup_code po_uom,
16491: D.matched_uom_lookup_code rcv_uom,
16492: rsl.item_id rcv_item_id
16493: FROM ap_invoice_distributions_all D,
16494: po_distributions_all PD,
16495: po_lines_all PL,
16496: po_line_locations_all PLL,
16497: rcv_transactions RTXN,
16498: rcv_shipment_lines RSL