DBA Data[Home] [Help]

APPS.INV_RCV_COMMON_APIS dependencies on OE_ORDER_LINES_ALL

Line 3695: FROM oe_order_lines_all oel, oe_order_headers_all oeh

3691: l_progress := '20';
3692: BEGIN
3693: SELECT COUNT (DISTINCT oel.order_quantity_uom)
3694: INTO l_count
3695: FROM oe_order_lines_all oel, oe_order_headers_all oeh
3696: WHERE oel.header_id = p_order_header_id
3697: --AND oel.ordered_item_id = p_item_id -- commented for Bug 12640725
3698: AND oel.inventory_item_id = p_item_id -- added for Bug 12640725
3699: AND NVL (OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id

Line 3723: FROM oe_order_lines_all oel

3719: p_organization_id,
3720: --oel.ordered_item_id) -- commented for Bug 12640725
3721: oel.inventory_item_id) -- added for Bug 12640725
3722: INTO x_uom_code
3723: FROM oe_order_lines_all oel
3724: WHERE oel.header_id = p_order_header_id
3725: --AND oel.ordered_item_id = p_item_id -- commented for Bug 12640725
3726: AND oel.inventory_item_id = p_item_id -- added for Bug 12640725
3727: AND oel.line_category_code = 'RETURN'

Line 4935: OE_ORDER_LINES_all OEL,

4931:
4932: SELECT DISTINCT(OEL.item_revision)
4933: INTO x_revision_code
4934: FROM
4935: OE_ORDER_LINES_all OEL,
4936: OE_ORDER_HEADERS_all OEH
4937: WHERE OEL.LINE_CATEGORY_CODE='RETURN'
4938: AND OEL.INVENTORY_ITEM_ID = p_item_id
4939: AND nvl(OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id