DBA Data[Home] [Help]

APPS.INV_ATTRIBUTE_CONTROL_PVT dependencies on STANDARD

Line 250: and item_type_code in ('MODEL','STANDARD','OPTION')

246: from oe_order_lines_all
247: where source_type_code = 'EXTERNAL'
248: and open_flag = 'Y'
249: and nvl(shipped_quantity,0) = 0
250: and item_type_code in ('MODEL','STANDARD','OPTION')
251: and FLOW_STATUS_CODE = 'AWAITING_RECEIPT'
252: and inventory_item_id = p_item_id
253: and ship_from_org_id = p_org_id
254: and rownum = 1;

Line 310: and item_type_code in ('MODEL','STANDARD','OPTION')

306: from oe_order_lines_all
307: where source_type_code = 'EXTERNAL'
308: and open_flag = 'Y'
309: and nvl(shipped_quantity,0) = 0
310: and item_type_code in ('MODEL','STANDARD','OPTION')
311: and FLOW_STATUS_CODE = 'AWAITING_RECEIPT'
312: and inventory_item_id = p_item_id
313: and ship_from_org_id = i.organization_id
314: and rownum = 1;