DBA Data[Home] [Help]

APPS.INV_UI_ITEM_ATT_LOVS dependencies on OE_ORDER_HEADERS_ALL

Line 69: OE_ORDER_HEADERS_all OEH

65:
66: For c_rma_line in ( select line_id
67: FROM
68: OE_ORDER_LINES_all OEL,
69: OE_ORDER_HEADERS_all OEH
70: WHERE OEL.LINE_CATEGORY_CODE='RETURN'
71: AND OEL.INVENTORY_ITEM_ID = p_item_id
72: AND nvl(OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id
73: AND OEL.HEADER_ID = OEH.HEADER_ID

Line 3762: OE_ORDER_HEADERS_all OEH

3758:
3759: For c_rma_line in ( select line_id
3760: FROM
3761: OE_ORDER_LINES_all OEL,
3762: OE_ORDER_HEADERS_all OEH
3763: WHERE OEL.LINE_CATEGORY_CODE='RETURN'
3764: AND OEL.INVENTORY_ITEM_ID = p_item_id
3765: AND nvl(OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id
3766: AND OEL.HEADER_ID = OEH.HEADER_ID

Line 4026: OE_ORDER_HEADERS_all OEH

4022:
4023: For c_rma_line in ( select line_id
4024: FROM
4025: OE_ORDER_LINES_all OEL,
4026: OE_ORDER_HEADERS_all OEH
4027: WHERE OEL.LINE_CATEGORY_CODE='RETURN'
4028: AND OEL.INVENTORY_ITEM_ID = p_item_id
4029: AND nvl(OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id
4030: AND OEL.HEADER_ID = OEH.HEADER_ID