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

737: oe_debug_pub.add( 'LINE SET ID NOT NULL '||L_LINE_REC.LINE_SET_ID , 3 ) ;
738: END IF;
739: SELECT count(*)
740: INTO l_count_unshipped
741: FROM oe_order_lines
742: WHERE line_set_id = l_line_rec.line_set_id
743: AND shipped_quantity IS NULL
744: AND line_id <> l_line_rec.line_id ;
745:

Line 758: FROM oe_order_lines

754: SELECT nvl(sum(shipped_quantity),0)
755: INTO l_del_shipping_quantity
756: FROM wsh_delivery_details
757: where source_line_id in (SELECT line_id
758: FROM oe_order_lines
759: WHERE line_set_id = l_line_rec.line_set_id
760: AND shipped_quantity IS NULL
761: AND line_id <> l_line_rec.line_id)
762: and source_code = 'OE'

Line 1018: FROM oe_order_lines

1014: , SUM(shipping_quantity)
1015: INTO l_x_ordered_quantity
1016: , l_x_shipped_quantity
1017: , l_x_shipping_quantity
1018: FROM oe_order_lines
1019: WHERE line_set_id = p_line_set_id;
1020:
1021: x_ordered_quantity := l_x_ordered_quantity;
1022: x_shipped_quantity := l_x_shipped_quantity;

Line 1149: update oe_order_lines

1145: END IF;
1146:
1147: SAVEPOINT Update_Shipping_Interface;
1148:
1149: update oe_order_lines
1150: set shipping_interfaced_flag = p_shipping_interfaced_flag,
1151: firm_demand_flag = NVL(l_firm_flag,firm_demand_flag),
1152: last_update_date = SYSDATE,
1153: last_updated_by = FND_GLOBAL.USER_ID,

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

1639: BEGIN
1640:
1641: SELECT line_id
1642: INTO l_config_line_id
1643: FROM oe_order_lines
1644: WHERE header_id = OE_LINE_SECURITY.g_record.header_id
1645: AND ato_line_id = OE_LINE_SECURITY.g_record.line_id
1646: AND item_type_code = 'CONFIG';
1647:

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