APPS.OE_SHIPPING_INTEGRATION_PUB dependencies on OE_ORDER_LINES_ALL

Line 1202: Update oe_order_lines_all

1198:
1199: IF l_firm_flag = 'Y' THEN
1200: IF l_line_tbl(1).ship_model_complete_flag = 'Y' THEN
1201:
1202: Update oe_order_lines_all
1203: Set firm_demand_flag = 'Y'
1204: Where top_model_line_id = l_line_tbl(1).top_model_line_id;
1205:
1206: ELSIF (l_line_tbl(1).ato_line_id is not null

Line 1214: Update oe_order_lines_all

1210: OE_GLOBALS.G_ITEM_OPTION,
1211: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352
1212: THEN
1213:
1214: Update oe_order_lines_all
1215: Set firm_demand_flag = 'Y'
1216: Where ato_line_id = l_line_tbl(1).ato_line_id;
1217:
1218: END IF;

Line 1311: From oe_order_lines_all

1307: Into l_ato_line_id,
1308: l_item_type_code,
1309: l_smc_flag,
1310: l_top_model_line_id
1311: From oe_order_lines_all
1312: Where line_id = p_line_id;
1313:
1314: IF l_smc_flag = 'Y' THEN
1315:

Line 1316: Update oe_order_lines_all

1312: Where line_id = p_line_id;
1313:
1314: IF l_smc_flag = 'Y' THEN
1315:
1316: Update oe_order_lines_all
1317: Set firm_demand_flag = 'Y'
1318: Where top_model_line_id = l_top_model_line_id;
1319: ELSIF (l_ato_line_id is not null
1320: AND NOT (l_ato_line_id = p_line_id AND

Line 1326: Update oe_order_lines_all

1322: OE_GLOBALS.G_ITEM_OPTION,
1323: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352
1324: THEN
1325:
1326: Update oe_order_lines_all
1327: Set firm_demand_flag = 'Y'
1328: Where ato_line_id = l_ato_line_id;
1329:
1330: END IF;

Line 1561: FROM oe_order_lines_all oel,

1557: x_return_status := FND_API.G_RET_STS_SUCCESS;
1558:
1559: SELECT oel.line_id
1560: INTO l_line_id
1561: FROM oe_order_lines_all oel,
1562: mtl_system_items msi
1563: WHERE oel.header_id = p_header_id
1564: AND (oel.ship_set_id = p_ship_set_id OR
1565: (oel.top_model_line_id = p_top_model_line_id AND

Line 1576: FROM oe_order_lines_all oel1

1572: msi.mtl_transactions_enabled_flag = 'Y'))
1573: AND oel.shipping_interfaced_flag = 'N'
1574: AND (oel.shippable_flag = 'Y' OR
1575: (EXISTS (SELECT 'Y'
1576: FROM oe_order_lines_all oel1
1577: WHERE oel1.header_id = p_header_id
1578: AND (oel1.ship_set_id = p_ship_set_id OR
1579: (oel1.top_model_line_id = p_top_model_line_id AND
1580: oel1.ship_model_complete_flag = 'Y'))

Line 1585: FROM oe_order_lines_all oel2

1581: AND oel1.ato_line_id = oel1.line_id
1582: AND oel1.item_type_code in ('MODEL','CLASS')
1583: AND oel1.ordered_quantity > 0
1584: AND NOT EXISTS (SELECT 'Y'
1585: FROM oe_order_lines_all oel2
1586: WHERE oel2.top_model_line_id
1587: = oel1.top_model_line_id
1588: AND oel2.ato_line_id
1589: = oel1.ato_line_id

Line 1715: FROM oe_order_lines_all oel

1711: END IF;
1712: BEGIN
1713: SELECT oel.line_id
1714: INTO l_line_id
1715: FROM oe_order_lines_all oel
1716: WHERE oel.header_id = l_header_id
1717: AND (oel.ship_set_id = l_ship_set_id OR
1718: oel.top_model_line_id = l_top_model_line_id)
1719: AND oel.shipping_interfaced_flag = 'N'

Line 1722: FROM oe_order_lines_all oel1

1718: oel.top_model_line_id = l_top_model_line_id)
1719: AND oel.shipping_interfaced_flag = 'N'
1720: AND (oel.shippable_flag = 'Y' OR
1721: (EXISTS (SELECT 'Y'
1722: FROM oe_order_lines_all oel1
1723: WHERE oel1.header_id = l_header_id
1724: AND (oel1.ship_set_id = l_ship_set_id OR
1725: oel1.top_model_line_id = l_top_model_line_id)
1726: AND oel1.ato_line_id = oel1.line_id

Line 1729: FROM oe_order_lines_all oel2

1725: oel1.top_model_line_id = l_top_model_line_id)
1726: AND oel1.ato_line_id = oel1.line_id
1727: AND oel1.item_type_code in ('MODEL','CLASS')
1728: AND NOT EXISTS (SELECT 'Y'
1729: FROM oe_order_lines_all oel2
1730: WHERE oel2.top_model_line_id
1731: = oel1.top_model_line_id
1732: AND oel2.ato_line_id
1733: = oel1.ato_line_id