DBA Data[Home] [Help]

APPS.INL_INTEGRATION_GRP dependencies on ZX_LINES_DET_FACTORS

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 1021: FROM zx_lines_det_factors zdf,

1017: l_product_type,
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

Line 3314: FROM zx_lines_det_factors zdf,

3310: l_lci_table(l_ind_lci).product_category,
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)