DBA Data[Home] [Help]

APPS.INV_UI_ITEM_ATT_LOVS dependencies on OE_ORDER_LINES_ALL

Line 68: OE_ORDER_LINES_all OEL,

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

Line 3761: OE_ORDER_LINES_all OEL,

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

Line 4025: OE_ORDER_LINES_all OEL,

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