DBA Data[Home] [Help]

APPS.INV_UI_ITEM_ATT_LOVS dependencies on OE_ORDER_HEADERS_ALL

Line 83: OE_ORDER_HEADERS_all OEH

79:
80: For c_rma_line in ( select line_id
81: FROM
82: OE_ORDER_LINES_all OEL,
83: OE_ORDER_HEADERS_all OEH
84: WHERE OEL.LINE_CATEGORY_CODE='RETURN'
85: AND OEL.INVENTORY_ITEM_ID = p_item_id
86: AND nvl(OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id
87: AND OEL.HEADER_ID = OEH.HEADER_ID

Line 3851: OE_ORDER_HEADERS_all OEH

3847:
3848: For c_rma_line in ( select line_id
3849: FROM
3850: OE_ORDER_LINES_all OEL,
3851: OE_ORDER_HEADERS_all OEH
3852: WHERE OEL.LINE_CATEGORY_CODE='RETURN'
3853: AND OEL.INVENTORY_ITEM_ID = p_item_id
3854: AND nvl(OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id
3855: AND OEL.HEADER_ID = OEH.HEADER_ID

Line 4115: OE_ORDER_HEADERS_all OEH

4111:
4112: For c_rma_line in ( select line_id
4113: FROM
4114: OE_ORDER_LINES_all OEL,
4115: OE_ORDER_HEADERS_all OEH
4116: WHERE OEL.LINE_CATEGORY_CODE='RETURN'
4117: AND OEL.INVENTORY_ITEM_ID = p_item_id
4118: AND nvl(OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id
4119: AND OEL.HEADER_ID = OEH.HEADER_ID