APPS.INL_INTEGRATION_GRP dependencies on PO_RELEASES

Line 2921: po_releases_all pr -- Bug 9734841

2917: 'Y' lcm_flag
2918: FROM po_headers_all ph,
2919: po_lines_all pl,
2920: po_line_locations_all pll,
2921: po_releases_all pr -- Bug 9734841
2922: WHERE ph.po_header_id = p_po_header_id
2923: AND pl.po_header_id = ph.po_header_id
2924: AND pll.po_line_id = pl.po_line_id
2925: AND NVL(pll.po_release_id, -999) = NVL(p_po_release_id, -999) -- Bug 14280113

Line 3526: l_simulation_rec.parent_table_name := 'PO_RELEASES';

3522:
3523:
3524: IF p_po_release_id IS NOT NULL THEN -- Bug 14280113
3525:
3526: l_simulation_rec.parent_table_name := 'PO_RELEASES';
3527: l_simulation_rec.parent_table_id := p_po_release_id;
3528:
3529: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
3530: p_procedure_name => l_api_name,

Line 3531: p_debug_info => 'Get data from PO RELEASES');

3527: l_simulation_rec.parent_table_id := p_po_release_id;
3528:
3529: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
3530: p_procedure_name => l_api_name,
3531: p_debug_info => 'Get data from PO RELEASES');
3532: SELECT ph.segment1, -- 01
3533: ph.vendor_id, -- 02
3534: ph.vendor_site_id, -- 03
3535: pr.revision_num, -- 04

Line 3558: po_releases_all pr

3554: l_po_hdr_rec.approved_date, -- 10
3555: l_simulation_rec.freight_code, -- 11
3556: l_simulation_rec.org_id -- 12
3557: FROM po_headers_all ph,
3558: po_releases_all pr
3559: WHERE ph.po_header_id = pr.po_header_id
3560: AND pr.po_release_id = p_po_release_id;
3561:
3562: ELSE

Line 3845: FROM po_releases pr

3841: -- Bug #9821615 -- AND (pll.po_release_id IS NULL
3842: -- Bug #9941402
3843: AND (ph.type_lookup_code IN ('PLANNED','BLANKET')
3844: AND EXISTS (SELECT po_release_id
3845: FROM po_releases pr
3846: WHERE pr.po_release_id = pll.po_release_id)
3847: OR ph.type_lookup_code = 'STANDARD');
3848:
3849: TYPE c_po_ln_loc_tp IS TABLE OF c_po_ln_loc%ROWTYPE;

Line 4317: po_releases pr, -- Bug 14280113

4313: FROM po_vendor_sites pvs1,
4314: po_vendors pv1,
4315: po_vendor_sites pvs,
4316: po_vendors pv,
4317: po_releases pr, -- Bug 14280113
4318: po_headers_all ph,
4319: inl_simulations s
4320: WHERE pr.po_header_id (+) = ph.po_header_id -- Bug 14280113
4321: AND pvs1.vendor_site_id = s.vendor_site_id

Line 4329: OR (s.parent_table_name = 'PO_RELEASES'

4325: -- Bug 14280113
4326: --AND ph.po_header_id = s.parent_table_id
4327: AND ((s.parent_table_name = 'PO_HEADERS'
4328: AND s.parent_table_id = ph.po_header_id)
4329: OR (s.parent_table_name = 'PO_RELEASES'
4330: AND s.parent_table_id = pr.po_release_id))
4331: AND s.simulation_id = p_simulation_id;
4332: EXCEPTION
4333: WHEN NO_DATA_FOUND THEN

Line 4425: l_parent_table_name = 'PO_RELEASES' THEN

4421: END IF;
4422:
4423: -- Bug 14280113 Check PO Release revision
4424: IF NVL(l_po_release_revision_num,0) <> NVL(l_simu_revision_num,0) AND
4425: l_parent_table_name = 'PO_RELEASES' THEN
4426: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
4427: p_procedure_name => l_proc_name,
4428: p_var_name => 'l_simu_revision_num',
4429: p_var_value => l_simu_revision_num);