APPS.CSD_HV_WIP_JOB_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1905: from mtl_system_items_b

1901:
1902: CURSOR get_inv_location_control_code ( p_organization_id NUMBER,
1903: p_inventory_item_id NUMBER ) IS
1904: SELECT location_control_code
1905: from mtl_system_items_b
1906: where
1907: organization_id = p_organization_id and
1908: inventory_item_id = p_inventory_item_id;
1909:

Line 2913: select location_control_code from mtl_system_items_b where

2909: secondary_inventory_name = p_secondary_inventory_name;
2910:
2911: CURSOR get_inv_location_control_code ( p_organization_id NUMBER,
2912: p_inventory_item_id NUMBER ) IS
2913: select location_control_code from mtl_system_items_b where
2914: organization_id = p_organization_id and
2915: inventory_item_id = p_inventory_item_id;
2916:
2917:

Line 4724: select location_control_code from mtl_system_items_b where

4720:
4721:
4722: CURSOR get_inv_location_control_code ( p_organization_id NUMBER,
4723: p_inventory_item_id NUMBER ) IS
4724: select location_control_code from mtl_system_items_b where
4725: organization_id = p_organization_id and
4726: inventory_item_id = p_inventory_item_id;
4727:
4728:

Line 4739: from mtl_system_items_b where

4735:
4736: CURSOR get_wip_supply_info ( p_organization_id NUMBER,
4737: p_inventory_item_id NUMBER ) IS
4738: select wip_supply_type, wip_supply_subinventory, wip_supply_locator_id
4739: from mtl_system_items_b where
4740: organization_id = p_organization_id and
4741: inventory_item_id = p_inventory_item_id;
4742: --bug#8465719 end
4743: