APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 280: FROM po_distributions_all a, po_line_locations_all b

276: ) IS
277: /*Bug 5879769 bduvarag start*/
278: /* CURSOR c_inv_organization_id(cp_po_distribution_id IN NUMBER) IS
279: SELECT b.ship_to_organization_id
280: FROM po_distributions_all a, po_line_locations_all b
281: WHERE a.line_location_id = b.line_location_id
282: AND a.po_distribution_id = cp_po_distribution_id;*/
283: lv_service_type_code jai_po_line_locations.service_type_code%TYPE;
284: ln_organization_id NUMBER;

Line 909: po_distributions_all pda,

905: AND invoice_id IN ( SELECT invoice_id
906: FROM ap_invoice_distributions_all
907: WHERE po_distribution_id IN ( SELECT pda.po_distribution_id
908: FROM po_line_locations_all pll,
909: po_distributions_all pda,
910: jai_po_line_locations jpll
911: WHERE pll.line_location_id = jpll.line_location_id
912: AND pll.line_location_id = pda.line_location_id
913: AND pll.ship_to_organization_id = p_organization_id

Line 975: FROM po_distributions_all a, po_lines_all b

971:
972:
973: CURSOR c_item_id(cp_po_distribution_id IN NUMBER) IS
974: SELECT b.item_id
975: FROM po_distributions_all a, po_lines_all b
976: WHERE po_distribution_id = cp_po_distribution_id
977: AND a.po_line_id = b.po_line_id;
978:
979: CURSOR c_batch_references(cp_batch_id IN NUMBER, cp_source IN VARCHAR2) IS

Line 1049: po_distributions_all pda,

1045: WHERE org_id = p_org_id
1046: AND po_distribution_id in
1047: (SELECT pda.po_distribution_id
1048: FROM po_line_locations_all pll,
1049: po_distributions_all pda,
1050: jai_po_line_locations jpll
1051: WHERE pll.line_location_id = jpll.line_location_id
1052: AND pll.line_location_id = pda.line_location_id
1053: AND pll.ship_to_organization_id = p_organization_id