APPS.OE_SHIPPING_INTEGRATION_PUB dependencies on OE_ORDER_LINES_ALL

Line 1179: Update oe_order_lines_all

1175:
1176: IF l_firm_flag = 'Y' THEN
1177: IF l_line_tbl(1).ship_model_complete_flag = 'Y' THEN
1178:
1179: Update oe_order_lines_all
1180: Set firm_demand_flag = 'Y'
1181: Where top_model_line_id = l_line_tbl(1).top_model_line_id;
1182:
1183: ELSIF (l_line_tbl(1).ato_line_id is not null

Line 1190: Update oe_order_lines_all

1186: (OE_GLOBALS.G_ITEM_STANDARD,
1187: OE_GLOBALS.G_ITEM_OPTION)))
1188: THEN
1189:
1190: Update oe_order_lines_all
1191: Set firm_demand_flag = 'Y'
1192: Where ato_line_id = l_line_tbl(1).ato_line_id;
1193:
1194: END IF;

Line 1287: From oe_order_lines_all

1283: Into l_ato_line_id,
1284: l_item_type_code,
1285: l_smc_flag,
1286: l_top_model_line_id
1287: From oe_order_lines_all
1288: Where line_id = p_line_id;
1289:
1290: IF l_smc_flag = 'Y' THEN
1291:

Line 1292: Update oe_order_lines_all

1288: Where line_id = p_line_id;
1289:
1290: IF l_smc_flag = 'Y' THEN
1291:
1292: Update oe_order_lines_all
1293: Set firm_demand_flag = 'Y'
1294: Where top_model_line_id = l_top_model_line_id;
1295: ELSIF (l_ato_line_id is not null
1296: AND NOT (l_ato_line_id = p_line_id AND

Line 1301: Update oe_order_lines_all

1297: l_item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1298: OE_GLOBALS.G_ITEM_OPTION)))
1299: THEN
1300:
1301: Update oe_order_lines_all
1302: Set firm_demand_flag = 'Y'
1303: Where ato_line_id = l_ato_line_id;
1304:
1305: END IF;

Line 1536: FROM oe_order_lines_all oel,

1532: x_return_status := FND_API.G_RET_STS_SUCCESS;
1533:
1534: SELECT oel.line_id
1535: INTO l_line_id
1536: FROM oe_order_lines_all oel,
1537: mtl_system_items msi
1538: WHERE oel.header_id = p_header_id
1539: AND (oel.ship_set_id = p_ship_set_id OR
1540: (oel.top_model_line_id = p_top_model_line_id AND

Line 1551: FROM oe_order_lines_all oel1

1547: msi.mtl_transactions_enabled_flag = 'Y'))
1548: AND oel.shipping_interfaced_flag = 'N'
1549: AND (oel.shippable_flag = 'Y' OR
1550: (EXISTS (SELECT 'Y'
1551: FROM oe_order_lines_all oel1
1552: WHERE oel1.header_id = p_header_id
1553: AND (oel1.ship_set_id = p_ship_set_id OR
1554: (oel1.top_model_line_id = p_top_model_line_id AND
1555: oel1.ship_model_complete_flag = 'Y'))

Line 1560: FROM oe_order_lines_all oel2

1556: AND oel1.ato_line_id = oel1.line_id
1557: AND oel1.item_type_code in ('MODEL','CLASS')
1558: AND oel1.ordered_quantity > 0
1559: AND NOT EXISTS (SELECT 'Y'
1560: FROM oe_order_lines_all oel2
1561: WHERE oel2.top_model_line_id
1562: = oel1.top_model_line_id
1563: AND oel2.ato_line_id
1564: = oel1.ato_line_id

Line 1690: FROM oe_order_lines_all oel

1686: END IF;
1687: BEGIN
1688: SELECT oel.line_id
1689: INTO l_line_id
1690: FROM oe_order_lines_all oel
1691: WHERE oel.header_id = l_header_id
1692: AND (oel.ship_set_id = l_ship_set_id OR
1693: oel.top_model_line_id = l_top_model_line_id)
1694: AND oel.shipping_interfaced_flag = 'N'

Line 1697: FROM oe_order_lines_all oel1

1693: oel.top_model_line_id = l_top_model_line_id)
1694: AND oel.shipping_interfaced_flag = 'N'
1695: AND (oel.shippable_flag = 'Y' OR
1696: (EXISTS (SELECT 'Y'
1697: FROM oe_order_lines_all oel1
1698: WHERE oel1.header_id = l_header_id
1699: AND (oel1.ship_set_id = l_ship_set_id OR
1700: oel1.top_model_line_id = l_top_model_line_id)
1701: AND oel1.ato_line_id = oel1.line_id

Line 1704: FROM oe_order_lines_all oel2

1700: oel1.top_model_line_id = l_top_model_line_id)
1701: AND oel1.ato_line_id = oel1.line_id
1702: AND oel1.item_type_code in ('MODEL','CLASS')
1703: AND NOT EXISTS (SELECT 'Y'
1704: FROM oe_order_lines_all oel2
1705: WHERE oel2.top_model_line_id
1706: = oel1.top_model_line_id
1707: AND oel2.ato_line_id
1708: = oel1.ato_line_id