DBA Data[Home] [Help]

APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on MTL_SYSTEM_ITEMS

Line 661: FROM mtl_system_items m

657: SELECT decode(mtl_transactions_enabled_flag,'Y','Y','N'),
658: -- J: W/V Changes
659: unit_weight,
660: unit_volume
661: FROM mtl_system_items m
662: WHERE m.inventory_item_id = p_inventory_item_id
663: AND m.organization_id = p_organization_id;
664:
665: --Bug fix 3658492.

Line 1367: FROM mtl_system_items

1363:
1364: BEGIN
1365: SELECT serial_number_control_code
1366: INTO l_serial_number_control
1367: FROM mtl_system_items
1368: WHERE inventory_item_id = del_det_int_rec.inventory_item_id
1369: AND organization_id = del_det_int_rec.organization_id;
1370:
1371: IF l_debug_on THEN

Line 2145: FROM mtl_system_items

2141:
2142: BEGIN
2143: SELECT serial_number_control_code
2144: INTO l_serial_number_control
2145: FROM mtl_system_items
2146: WHERE inventory_item_id = del_det_int_rec.inventory_item_id
2147: AND organization_id = del_det_int_rec.organization_id;
2148:
2149: IF l_debug_on THEN