DBA Data[Home] [Help]

APPS.INV_RCV_COMMON_APIS dependencies on OE_ORDER_LINES_ALL

Line 4412: OE_ORDER_LINES_all OEL,

4408:
4409: SELECT DISTINCT(OEL.item_revision)
4410: INTO x_revision_code
4411: FROM
4412: OE_ORDER_LINES_all OEL,
4413: OE_ORDER_HEADERS_all OEH
4414: WHERE OEL.LINE_CATEGORY_CODE='RETURN'
4415: AND OEL.INVENTORY_ITEM_ID = p_item_id
4416: AND nvl(OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id