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.INV_LABEL_PVT4 dependencies on CST_COST_GROUPS

Line 910: , cst_cost_groups ccg

906: , sum(nvl(l_secondary_transaction_qty,wlc.secondary_quantity)) secondary_quantity -- invconv fabdi
907: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
908: FROM wms_lpn_contents wlc
909: , wms_license_plate_numbers plpn
910: , cst_cost_groups ccg
911: , mtl_item_locations milkfv
912: ,(SELECT distinct LPN_ID
913: FROM WMS_LICENSE_PLATE_NUMBERS PLPN
914: WHERE 1 = 1 START WITH LPN_ID = p_lpn_id CONNECT BY PARENT_LPN_ID = PRIOR LPN_ID ) lid -- Added for bug# 14493747

Line 967: , cst_cost_groups ccg

963: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
964: , sum(nvl(l_secondary_transaction_qty,mmtt.secondary_transaction_quantity)) secondary_quantity -- invconv fabdi
965: , mmtt.secondary_uom_code secondary_uom -- invconv fabdi
966: FROM wms_license_plate_numbers plpn
967: , cst_cost_groups ccg
968: , mtl_item_locations milkfv
969: , mtl_material_transactions_temp mmtt
970: -- Bug 4137707, Do not need to include this where clause,
971: -- This will be controlled when opening this cursor

Line 1029: , cst_cost_groups ccg

1025: , l_secondary_uom_code secondary_uom -- invconv fabdi
1026: FROM wms_packaging_hist wpc
1027: , mtl_material_transactions_temp mmtt
1028: , mtl_system_items msi
1029: , cst_cost_groups ccg
1030: , mtl_item_locations milkfv
1031: -- Bug 4137707, Do not need to include this where clause,
1032: -- This will be controlled when opening this cursor
1033: -- WHERE cartonization_flag = 1 --Cartonization Flow

Line 1254: , cst_cost_groups ccg

1250: , p_lot_number VARCHAR) IS
1251: SELECT msn.cost_group_id
1252: , ccg.cost_group
1253: FROM mtl_serial_numbers msn
1254: , cst_cost_groups ccg
1255: WHERE msn.lpn_id = p_lpn_id
1256: AND msn.inventory_item_id = p_inventory_item_id
1257: AND msn.lot_number = p_lot_number
1258: AND msn.cost_group_id = ccg.cost_group_id;

Line 1306: FROM wms_license_plate_numbers plpn, cst_cost_groups ccg, mtl_item_locations milkfv,

1302: , milkfv.inventory_location_id locator_id
1303: , inv_project.get_locsegs(milkfv.inventory_location_id, milkfv.organization_id) LOCATOR
1304: , sum(nvl(l_secondary_transaction_qty,mcce.count_quantity_current)) secondary_quantity
1305: , mcce.count_uom_current secondary_uom
1306: FROM wms_license_plate_numbers plpn, cst_cost_groups ccg, mtl_item_locations milkfv,
1307: mtl_cycle_count_entries mcce
1308: WHERE cartonization_flag = 0 -- non Cartonization Flow
1309: AND plpn.lpn_id(+) = p_lpn_id
1310: AND milkfv.organization_id(+) = NVL(p_organization_id, plpn.organization_id)