DBA Data[Home] [Help]

APPS.INV_UI_ITEM_ATT_LOVS dependencies on OE_ORDER_LINES_ALL

Line 82: OE_ORDER_LINES_all OEL,

78: IF ( l_enforce_rma_sn = 'Y' and p_oe_order_header_id is not null) THEN
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

Line 3850: OE_ORDER_LINES_all OEL,

3846: IF ( l_enforce_rma_sn = 'Y' and p_oe_order_header_id is not null) THEN
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

Line 4114: OE_ORDER_LINES_all OEL,

4110: IF ( l_enforce_rma_sn = 'Y' and p_oe_order_header_id is not null) THEN
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