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_B

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 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