DBA Data[Home] [Help]

APPS.OE_RESERVE_CONC dependencies on MTL_SYSTEM_ITEMS

Line 60: FROM mtl_system_items_b

56: -- Getting the Primary UOM of the item
57: BEGIN
58: SELECT primary_uom_code
59: INTO l_primary_uom
60: FROM mtl_system_items_b
61: WHERE inventory_item_id = p_inventory_item_id
62: AND organization_id = NVL(p_ship_from_org_id,
63: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_org_id)); --4759251
64: EXCEPTION

Line 860: FROM mtl_system_items msi

856: BEGIN
857:
858: SELECT msi.lot_control_code
859: INTO l_lot_control_code
860: FROM mtl_system_items msi
861: WHERE msi.inventory_item_id = p_inventory_item_id
862: AND msi.organization_id = p_ship_from_org_id;
863:
864: IF l_lot_control_code = 2 THEN

Line 1004: FROM mtl_system_items_b

1000: -- Getting the Primary UOM of the item
1001: BEGIN
1002: SELECT primary_uom_code
1003: INTO l_primary_uom
1004: FROM mtl_system_items_b
1005: WHERE inventory_item_id = p_inventory_item_id
1006: AND organization_id = NVL(p_ship_from_org_id,
1007: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_rsv_tbl(1).org_id)); --4759251
1008: EXCEPTION

Line 2389: l_stmt := 'SELECT Line_id, l.org_id FROM OE_ORDER_LINES l, OE_ORDER_HEADERS_ALL h ,MTL_SYSTEM_ITEMS msi ';

2385: 'rset.reservation_set_name=:reservation_set_name';
2386:
2387: ELSE
2388: --Moac
2389: l_stmt := 'SELECT Line_id, l.org_id FROM OE_ORDER_LINES l, OE_ORDER_HEADERS_ALL h ,MTL_SYSTEM_ITEMS msi ';
2390: l_stmt := l_stmt|| ' WHERE NVL(h.cancelled_flag,'||'''N'''||') <> ' ||'''Y'''||
2391: ' AND h.header_id = l.header_id'||
2392: ' AND h.open_flag = '||'''Y'''||
2393: ' AND NVL(l.cancelled_flag,'||'''N'''||') <> '||'''Y'''||