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_SCHEDULE_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 543: FROM mtl_system_items_vl

539: BEGIN
540:
541: SELECT concatenated_segments
542: INTO l_ordered_item
543: FROM mtl_system_items_vl
544: WHERE inventory_item_id = l_inventory_item_id
545: AND organization_id = l_ship_from_org_id;
546:
547: EXCEPTION

Line 895: FROM MTL_SYSTEM_ITEMS

891: x_return_status := FND_API.G_RET_STS_SUCCESS;
892:
893: SELECT RESERVABLE_TYPE
894: INTO l_reservable_type
895: FROM MTL_SYSTEM_ITEMS
896: WHERE INVENTORY_ITEM_ID = p_line_rec.inventory_item_id
897: AND ORGANIZATION_ID = p_line_rec.ship_from_org_id;
898:
899: IF l_reservable_type = 1 THEN

Line 934: FROM mtl_system_items

930: SELECT revision_qty_control_code, lot_control_code,
931: serial_number_control_code
932: INTO l_revision_code, l_lot_code,
933: l_serial_code
934: FROM mtl_system_items
935: WHERE inventory_item_id = p_line_rec.inventory_item_id
936: AND organization_id = p_line_rec.ship_from_org_id;
937:
938: EXCEPTION

Line 6917: FROM mtl_system_items msi

6913: END IF;
6914:
6915: SELECT msi.lot_control_code
6916: INTO l_lot_control_code
6917: FROM mtl_system_items msi
6918: WHERE msi.inventory_item_id = p_item_id
6919: AND msi.organization_id = nvl(p_org_id,l_org_id);
6920:
6921: IF l_lot_control_code = 2 THEN

Line 7054: l_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;

7050: l_avail_to_reserve2 NUMBER; -- INVCONV
7051:
7052: --ER#14763609
7053: l_fulfillment_base oe_order_lines_all.fulfillment_base%type;
7054: l_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;
7055: l_primary_uom_code mtl_system_items_b.primary_uom_code%type;
7056: l_on_hand_ord_qty NUMBER ;
7057: l_avail_to_reserve_ord NUMBER ;
7058: l_sub_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;

Line 7055: l_primary_uom_code mtl_system_items_b.primary_uom_code%type;

7051:
7052: --ER#14763609
7053: l_fulfillment_base oe_order_lines_all.fulfillment_base%type;
7054: l_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;
7055: l_primary_uom_code mtl_system_items_b.primary_uom_code%type;
7056: l_on_hand_ord_qty NUMBER ;
7057: l_avail_to_reserve_ord NUMBER ;
7058: l_sub_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;
7059: l_sub_primary_uom_code mtl_system_items_b.primary_uom_code%type;

Line 7058: l_sub_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;

7054: l_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;
7055: l_primary_uom_code mtl_system_items_b.primary_uom_code%type;
7056: l_on_hand_ord_qty NUMBER ;
7057: l_avail_to_reserve_ord NUMBER ;
7058: l_sub_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;
7059: l_sub_primary_uom_code mtl_system_items_b.primary_uom_code%type;
7060: l_sub_on_hand_ord_qty NUMBER ;
7061: l_sub_avail_to_reserve_ord NUMBER ;
7062: --End ER#14763609

Line 7059: l_sub_primary_uom_code mtl_system_items_b.primary_uom_code%type;

7055: l_primary_uom_code mtl_system_items_b.primary_uom_code%type;
7056: l_on_hand_ord_qty NUMBER ;
7057: l_avail_to_reserve_ord NUMBER ;
7058: l_sub_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;
7059: l_sub_primary_uom_code mtl_system_items_b.primary_uom_code%type;
7060: l_sub_on_hand_ord_qty NUMBER ;
7061: l_sub_avail_to_reserve_ord NUMBER ;
7062: --End ER#14763609
7063:

Line 7190: FROM mtl_system_items_b

7186: END IF;
7187:
7188: SELECT secondary_uom_code ,primary_uom_code
7189: INTO l_secondary_uom_code ,l_primary_uom_code
7190: FROM mtl_system_items_b
7191: WHERE inventory_item_id = g_atp_tbl(K).inventory_item_id
7192: AND organization_id = g_atp_tbl(K).ship_from_org_id
7193: AND ROWNUM=1;
7194:

Line 7342: FROM mtl_system_items_b

7338: END IF;
7339:
7340: SELECT secondary_uom_code ,primary_uom_code
7341: INTO l_secondary_uom_code ,l_primary_uom_code
7342: FROM mtl_system_items_b
7343: WHERE inventory_item_id = g_atp_tbl(K).request_item_id
7344: AND organization_id = g_atp_tbl(K).ship_from_org_id
7345: AND ROWNUM=1;
7346: IF l_debug_level > 0 THEN

Line 11593: FROM mtl_system_items

11589: BEGIN
11590:
11591: SELECT planning_make_buy_code
11592: INTO l_make_buy
11593: FROM mtl_system_items
11594: WHERE inventory_item_id = p_line_rec.inventory_item_id
11595: AND ORGANIZATION_ID = nvl(p_line_rec.ship_from_org_id,
11596: l_org_id);
11597:

Line 12590: FROM MTL_SYSTEM_ITEMS MSI

12586: , db_primary_uom_code
12587: , db_model_item_id
12588: , db_line_unit_code
12589: , primary_model_qty
12590: FROM MTL_SYSTEM_ITEMS MSI
12591: , OE_ORDER_LINES OL
12592: WHERE MSI.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID
12593: AND MSI.ORGANIZATION_ID = p_ship_from_org_id
12594: AND OL.LINE_ID = p_ato_line_id ;

Line 14041: l_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;

14037: l_avail_to_reserve2 NUMBER; -- invconv
14038: l_process_flag VARCHAR2(1) := FND_API.G_FALSE;
14039: --ER#14763609
14040: l_fulfillment_base oe_order_lines_all.fulfillment_base%type;
14041: l_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;
14042: l_primary_uom_code mtl_system_items_b.primary_uom_code%type;
14043: l_on_hand_ord_qty NUMBER ;
14044: l_avail_to_reserve_ord NUMBER ;
14045: l_sub_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;

Line 14042: l_primary_uom_code mtl_system_items_b.primary_uom_code%type;

14038: l_process_flag VARCHAR2(1) := FND_API.G_FALSE;
14039: --ER#14763609
14040: l_fulfillment_base oe_order_lines_all.fulfillment_base%type;
14041: l_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;
14042: l_primary_uom_code mtl_system_items_b.primary_uom_code%type;
14043: l_on_hand_ord_qty NUMBER ;
14044: l_avail_to_reserve_ord NUMBER ;
14045: l_sub_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;
14046: l_sub_primary_uom_code mtl_system_items_b.primary_uom_code%type;

Line 14045: l_sub_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;

14041: l_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;
14042: l_primary_uom_code mtl_system_items_b.primary_uom_code%type;
14043: l_on_hand_ord_qty NUMBER ;
14044: l_avail_to_reserve_ord NUMBER ;
14045: l_sub_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;
14046: l_sub_primary_uom_code mtl_system_items_b.primary_uom_code%type;
14047: l_sub_on_hand_ord_qty NUMBER ;
14048: l_sub_avail_to_reserve_ord NUMBER ;
14049: --End ER#14763609

Line 14046: l_sub_primary_uom_code mtl_system_items_b.primary_uom_code%type;

14042: l_primary_uom_code mtl_system_items_b.primary_uom_code%type;
14043: l_on_hand_ord_qty NUMBER ;
14044: l_avail_to_reserve_ord NUMBER ;
14045: l_sub_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;
14046: l_sub_primary_uom_code mtl_system_items_b.primary_uom_code%type;
14047: l_sub_on_hand_ord_qty NUMBER ;
14048: l_sub_avail_to_reserve_ord NUMBER ;
14049: --End ER#14763609
14050:

Line 14158: FROM mtl_system_items_b

14154: END IF;
14155:
14156: SELECT secondary_uom_code ,primary_uom_code
14157: INTO l_secondary_uom_code ,l_primary_uom_code
14158: FROM mtl_system_items_b
14159: WHERE inventory_item_id = g_atp_tbl(K).inventory_item_id
14160: AND organization_id = g_atp_tbl(K).ship_from_org_id
14161: AND ROWNUM=1;
14162:

Line 14379: FROM mtl_system_items_b

14375: END IF;
14376:
14377: SELECT secondary_uom_code ,primary_uom_code
14378: INTO l_secondary_uom_code ,l_primary_uom_code
14379: FROM mtl_system_items_b
14380: WHERE inventory_item_id = g_atp_tbl(K).request_item_id
14381: AND organization_id = g_atp_tbl(K).ship_from_org_id
14382: AND ROWNUM=1;
14383: IF l_debug_level > 0 THEN

Line 18728: FROM MTL_SYSTEM_ITEMS

18724: BEGIN
18725: BEGIN
18726: SELECT shippable_item_flag
18727: INTO l_shippable_flag
18728: FROM MTL_SYSTEM_ITEMS
18729: WHERE INVENTORY_ITEM_ID = p_new_inventory_item_id
18730: AND ORGANIZATION_ID = p_new_ship_from_org_id;
18731:
18732: IF l_shippable_flag <> p_old_shippable_flag THEN