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 745: , cst_cost_groups ccg

741: , sum(nvl(l_secondary_transaction_qty,wlc.secondary_quantity)) secondary_quantity -- invconv fabdi
742: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
743: FROM wms_lpn_contents wlc
744: , wms_license_plate_numbers plpn
745: , cst_cost_groups ccg
746: , mtl_item_locations milkfv
747: -- Bug 4137707, Do not need to include this where clause,
748: -- This will be controlled when opening this cursor
749: --WHERE cartonization_flag = 0 -- non Cartonization Flow

Line 798: , cst_cost_groups ccg

794: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
795: , sum(nvl(l_secondary_transaction_qty,mmtt.secondary_transaction_quantity)) secondary_quantity -- invconv fabdi
796: , mmtt.secondary_uom_code secondary_uom -- invconv fabdi
797: FROM wms_license_plate_numbers plpn
798: , cst_cost_groups ccg
799: , mtl_item_locations milkfv
800: , mtl_material_transactions_temp mmtt
801: -- Bug 4137707, Do not need to include this where clause,
802: -- This will be controlled when opening this cursor

Line 855: , cst_cost_groups ccg

851: , l_secondary_uom_code secondary_uom -- invconv fabdi
852: FROM wms_packaging_hist wpc
853: , mtl_material_transactions_temp mmtt
854: , mtl_system_items msi
855: , cst_cost_groups ccg
856: , mtl_item_locations milkfv
857: -- Bug 4137707, Do not need to include this where clause,
858: -- This will be controlled when opening this cursor
859: -- WHERE cartonization_flag = 1 --Cartonization Flow

Line 1027: , cst_cost_groups ccg

1023: , p_lot_number VARCHAR) IS
1024: SELECT msn.cost_group_id
1025: , ccg.cost_group
1026: FROM mtl_serial_numbers msn
1027: , cst_cost_groups ccg
1028: WHERE msn.lpn_id = p_lpn_id
1029: AND msn.inventory_item_id = p_inventory_item_id
1030: AND msn.lot_number = p_lot_number
1031: AND msn.cost_group_id = ccg.cost_group_id;

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

1075: , milkfv.inventory_location_id locator_id
1076: , inv_project.get_locsegs(milkfv.inventory_location_id, milkfv.organization_id) LOCATOR
1077: , sum(nvl(l_secondary_transaction_qty,mcce.count_quantity_current)) secondary_quantity
1078: , mcce.count_uom_current secondary_uom
1079: FROM wms_license_plate_numbers plpn, cst_cost_groups ccg, mtl_item_locations milkfv,
1080: mtl_cycle_count_entries mcce
1081: WHERE cartonization_flag = 0 -- non Cartonization Flow
1082: AND plpn.lpn_id(+) = p_lpn_id
1083: AND milkfv.organization_id(+) = NVL(p_organization_id, plpn.organization_id)