APPS.INVIDIT3 dependencies on OE_ORDER_LINES_ALL

Line 892: from oe_order_lines_all l

888: and attribute_name=attr_name;
889:
890: if (shipping_level = 0) then
891: select count(1) into X_so_ship -- bug 10405137
892: from oe_order_lines_all l
893: where l.inventory_item_id = p_item_id
894: and l.open_flag = 'Y'
895: and nvl(l.shipping_interfaced_flag,'N') = 'N'
896: and l.ship_from_org_id = p_org_id

Line 900: from oe_order_lines_all l

896: and l.ship_from_org_id = p_org_id
897: and rownum = 1;
898: else
899: select count(1) into X_so_ship -- bug 10405137
900: from oe_order_lines_all l
901: where l.inventory_item_id = p_item_id
902: and l.open_flag = 'Y'
903: and nvl(l.shipping_interfaced_flag,'N') = 'N'
904: and l.ship_from_org_id in

Line 945: Modified the below SQL to use the oe_order_lines_all Table

941: END IF;
942: -- Bug 4139938 end
943:
944: /* Bug 1923215
945: Modified the below SQL to use the oe_order_lines_all Table
946: as so_lines_all and so_line_details are obsoleted in R11i
947: */
948: -- Check for open sales order line with a different value for
949: -- so_transactions_flag than in mtl_system_items

Line 957: from oe_order_lines_all l

953: attr_name := 'MTL_SYSTEM_ITEMS.SO_TRANSACTIONS_FLAG';
954: IF X_so_txn IS NOT NULL THEN
955: select count(1)
956: into X_so_txn
957: from oe_order_lines_all l
958: where l.inventory_item_id = p_item_id
959: and l.open_flag = 'Y' -- Bug 8435071
960: and (l.ship_from_org_id in
961: (select organization_id

Line 978: ( select * from oe_order_lines_all

974: -- Check for open sales order line for the item
975: IF X_so_open_exists IS NOT NULL THEN
976: select count(*) into X_so_open_exists from dual
977: where exists
978: ( select * from oe_order_lines_all
979: where inventory_item_id = p_item_id
980: and open_flag = 'Y' -- Bug 8435071
981: );
982: END IF;

Line 998: from oe_order_lines_all

994:
995: /*
996: select count(1)
997: into X_demand_exists
998: from oe_order_lines_all
999: where inventory_item_id = p_item_id
1000: and visible_demand_flag = 'Y'
1001: and shipped_quantity is NOT null
1002: and (ship_from_org_id in