DBA Data[Home] [Help]

APPS.INL_INTEGRATION_GRP dependencies on PO_LINES

Line 1023: po_lines_all pl, --Bug#9884458

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
1027: AND muom.unit_of_measure = pl.unit_meas_lookup_code --Bug#9884458

Line 2919: po_lines_all pl,

2915: pll.value_basis,
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

Line 3033: p_debug_info => 'Get PO Lines info');

3029:
3030: INL_LOGGING_PVT.Log_Statement (
3031: p_module_name => g_module_name,
3032: p_procedure_name => l_proc_name,
3033: p_debug_info => 'Get PO Lines info');
3034:
3035: -- If any errors happen abort the process.
3036: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3037: RAISE FND_API.G_EXC_ERROR;

Line 3789: -- Function : Check PO Lines Against Ship Lines

3785:
3786: -- Bug #9279355
3787: -- Utility : Check_POAgainstShipLines
3788: -- Type : Group
3789: -- Function : Check PO Lines Against Ship Lines
3790: --
3791: -- Pre-reqs : None
3792: -- Parameters :
3793: -- IN : p_simulation_id IN NUMBER

Line 3818: po_lines pl,

3814: pll.shipment_num,
3815: pl.line_num,
3816: ph.segment1
3817: FROM po_line_locations pll,
3818: po_lines pl,
3819: po_headers ph,
3820: inl_simulations s
3821: WHERE INV_UTILITIES.inv_check_lcm(
3822: pl.item_id,

Line 4049: po_lines pl,

4045: l_po_ln_num,
4046: l_po_currency,
4047: l_po_number
4048: FROM po_line_locations pll,
4049: po_lines pl,
4050: po_headers ph
4051: WHERE ph.po_header_id = pl.po_header_id
4052: AND pl.po_line_id = pll.po_line_id
4053: AND pll.line_location_id = c_ship_ln_tab(i).ship_line_source_id;

Line 4721: po_lines_all pl,

4717: ph.vendor_site_id,
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;