APPS.INL_INTEGRATION_GRP dependencies on PO_LINE_LOCATIONS_ALL

Line 1002: p_debug_info => 'Get values from zx_lines_det_factors and po_line_locations_all');

998: IF l_source_document_code = 'PO' THEN
999: INL_LOGGING_PVT.Log_Statement (
1000: p_module_name => g_module_name,
1001: p_procedure_name => l_proc_name,
1002: p_debug_info => 'Get values from zx_lines_det_factors and po_line_locations_all');
1003:
1004:
1005: SELECT zdf.trx_business_category,
1006: zdf.line_intended_use,

Line 1022: po_line_locations_all pll,

1018: l_user_defined_fisc_class,
1019: l_output_tax_classf_code,
1020: l_po_UOM_code --Bug#9884458
1021: FROM zx_lines_det_factors zdf,
1022: po_line_locations_all pll,
1023: po_lines_all pl, --Bug#9884458
1024: mtl_units_of_measure muom --Bug#9884458
1025: WHERE pll.line_location_id = p_int_rec(i).po_line_location_id
1026: AND pll.po_line_id = pl.po_line_id --Bug#9884458

Line 2920: po_line_locations_all pll,

2916: pll.matching_basis,
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

Line 3315: po_line_locations_all pll

3311: l_lci_table(l_ind_lci).product_type,
3312: l_lci_table(l_ind_lci).user_def_fiscal_class,
3313: l_lci_table(l_ind_lci).tax_classification_code
3314: FROM zx_lines_det_factors zdf,
3315: po_line_locations_all pll
3316: WHERE pll.line_location_id = c_pll_tab(i).line_location_id
3317: AND zdf.application_id = 201
3318: AND zdf.trx_id = NVL(pll.po_release_id,pll.po_header_id)
3319: AND zdf.trx_line_id = pll.line_location_id

Line 4722: po_line_locations_all pll

4718: pl.item_id,
4719: pll.ship_to_organization_id
4720: FROM po_headers_all ph,
4721: po_lines_all pl,
4722: po_line_locations_all pll
4723: WHERE ph.po_header_id = pl.po_header_id
4724: AND pl.po_line_id = pll.po_line_id
4725: AND ph.po_header_id = p_po_header_id;
4726: