eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_SHIPPING_INTEGRATION_PUB dependencies on OE_ORDER_LINES

Line 80: will be called whenever "SHIPPED_QUANTITY" column in OE_ORDER_LINES is

76: END Is_Activity_Shipping;
77:
78: /*
79: This procedure releases the BLOCK on "SHIP_LINE" activity. This Procedure
80: will be called whenever "SHIPPED_QUANTITY" column in OE_ORDER_LINES is
81: updated or a non-shippable line reaches the SHIP_LINE activity.
82: */
83:
84: PROCEDURE Complete_Ship_Line_Activity

Line 718: FROM oe_order_lines

714: oe_debug_pub.add( 'LINE SET ID NOT NULL '||L_LINE_REC.LINE_SET_ID , 3 ) ;
715: END IF;
716: SELECT count(*)
717: INTO l_count_unshipped
718: FROM oe_order_lines
719: WHERE line_set_id = l_line_rec.line_set_id
720: AND shipped_quantity IS NULL
721: AND line_id <> l_line_rec.line_id ;
722:

Line 735: FROM oe_order_lines

731: SELECT nvl(sum(shipped_quantity),0)
732: INTO l_del_shipping_quantity
733: FROM wsh_delivery_details
734: where source_line_id in (SELECT line_id
735: FROM oe_order_lines
736: WHERE line_set_id = l_line_rec.line_set_id
737: AND shipped_quantity IS NULL
738: AND line_id <> l_line_rec.line_id)
739: and source_code = 'OE'

Line 995: FROM oe_order_lines

991: , SUM(shipping_quantity)
992: INTO l_x_ordered_quantity
993: , l_x_shipped_quantity
994: , l_x_shipping_quantity
995: FROM oe_order_lines
996: WHERE line_set_id = p_line_set_id;
997:
998: x_ordered_quantity := l_x_ordered_quantity;
999: x_shipped_quantity := l_x_shipped_quantity;

Line 1126: update oe_order_lines

1122: END IF;
1123:
1124: SAVEPOINT Update_Shipping_Interface;
1125:
1126: update oe_order_lines
1127: set shipping_interfaced_flag = p_shipping_interfaced_flag,
1128: firm_demand_flag = NVL(l_firm_flag,firm_demand_flag),
1129: last_update_date = SYSDATE,
1130: last_updated_by = FND_GLOBAL.USER_ID,

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 1618: FROM oe_order_lines

1614: BEGIN
1615:
1616: SELECT line_id
1617: INTO l_config_line_id
1618: FROM oe_order_lines
1619: WHERE header_id = OE_LINE_SECURITY.g_record.header_id
1620: AND ato_line_id = OE_LINE_SECURITY.g_record.line_id
1621: AND item_type_code = 'CONFIG';
1622:

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