APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 1075: FROM po_distributions_all a, po_line_locations_all b

1071: ) IS
1072: /*Bug 5879769 bduvarag start*/
1073: /* CURSOR c_inv_organization_id(cp_po_distribution_id IN NUMBER) IS
1074: SELECT b.ship_to_organization_id
1075: FROM po_distributions_all a, po_line_locations_all b
1076: WHERE a.line_location_id = b.line_location_id
1077: AND a.po_distribution_id = cp_po_distribution_id;*/
1078:
1079: -- Added for bug#7191302 by Xiao, begin.

Line 1733: FROM po_line_locations_all po,ap_invoice_lines_all ap

1729: AND parent_invoice_line_number IS NULL;
1730:
1731: CURSOR get_po_matched_org_cur(pn_line_number NUMBER) IS
1732: SELECT po.ship_to_organization_id, po.ship_to_location_id
1733: FROM po_line_locations_all po,ap_invoice_lines_all ap
1734: WHERE po.line_location_id = ap.po_line_location_id
1735: AND ap.invoice_id = p_invoice_id
1736: AND ap.line_number = pn_line_number;
1737:

Line 1885: FROM po_line_locations_all po

1881: )
1882: OR EXISTS
1883: (
1884: SELECT 1
1885: FROM po_line_locations_all po
1886: , ap_invoice_lines_all line
1887: WHERE ai.invoice_id = line.invoice_id
1888: AND line.po_line_location_id = po.line_location_id
1889: AND (line.match_type = 'ITEM_TO_RECEIPT'

Line 1917: FROM po_line_locations_all pll,

1913: AND line_type_lookup_code = jai_constants.prepay_line
1914: AND invoice_id IN ( SELECT invoice_id
1915: FROM ap_invoice_distributions_all
1916: WHERE po_distribution_id IN ( SELECT pda.po_distribution_id
1917: FROM po_line_locations_all pll,
1918: po_distributions_all pda,
1919: jai_po_line_locations jpll
1920: WHERE pll.line_location_id = jpll.line_location_id
1921: AND pll.line_location_id = pda.line_location_id

Line 2212: FROM po_line_locations_all pll,

2208: FROM ap_invoice_distributions_all
2209: WHERE org_id = p_org_id
2210: AND po_distribution_id in
2211: (SELECT pda.po_distribution_id
2212: FROM po_line_locations_all pll,
2213: po_distributions_all pda,
2214: jai_po_line_locations jpll
2215: WHERE pll.line_location_id = jpll.line_location_id
2216: AND pll.line_location_id = pda.line_location_id