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_INV_LOVS dependencies on CST_COST_GROUPS

Line 706: FROM cst_cost_groups

702: -- organization
703: /* SELECT cost_group
704: , cost_group_id
705: , description
706: FROM cst_cost_groups
707: WHERE cost_group LIKE (p_cost_group); */
708: select ccg.cost_group ,ccga.cost_group_id, ccg.description
709: from cst_cost_groups ccg, cst_cost_group_accounts ccga
710: where ccg.cost_group_id = ccga.cost_group_id

Line 709: from cst_cost_groups ccg, cst_cost_group_accounts ccga

705: , description
706: FROM cst_cost_groups
707: WHERE cost_group LIKE (p_cost_group); */
708: select ccg.cost_group ,ccga.cost_group_id, ccg.description
709: from cst_cost_groups ccg, cst_cost_group_accounts ccga
710: where ccg.cost_group_id = ccga.cost_group_id
711: and ccga.organization_id = nvl(p_organization_id, ccga.organization_id)
712: --WHERE organization_id = p_organization_id
713: and ccg.cost_group LIKE (p_cost_group);

Line 758: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq

754: OPEN x_cost_group_lov FOR
755: SELECT ccg.cost_group
756: , ccg.cost_group_id
757: , ccg.description
758: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq
759: WHERE ccg.cost_group LIKE (p_from_cost_group)
760: AND ccg.cost_group_id = moq.cost_group_id
761: AND ccg.cost_group_type <> 1 --PJM-WMS Integration
762: AND ((moq.revision = p_revision)

Line 779: FROM cst_cost_groups ccg, wms_lpn_contents wlc

775: OPEN x_cost_group_lov FOR
776: SELECT ccg.cost_group
777: , ccg.cost_group_id
778: , ccg.description
779: FROM cst_cost_groups ccg, wms_lpn_contents wlc
780: WHERE ccg.cost_group LIKE (p_from_cost_group)
781: AND ccg.cost_group_id = wlc.cost_group_id
782: AND ccg.cost_group_type <> 1 --PJM-WMS Integration
783: AND ((wlc.revision = p_revision)

Line 798: FROM cst_cost_groups ccg, cst_cost_group_accounts ccga

794: OPEN x_cost_group_lov FOR
795: SELECT ccg.cost_group
796: , ccg.cost_group_id
797: , ccg.description
798: FROM cst_cost_groups ccg, cst_cost_group_accounts ccga
799: WHERE ccg.cost_group LIKE (p_to_cost_group)
800: AND ccg.cost_group_id = ccga.cost_group_id
801: AND ccga.cost_group_id <> p_from_cost_group_id
802: AND ccg.cost_group_type <> 1 --PJM-WMS Integration

Line 826: FROM cst_cost_groups

822: OPEN x_cost_group_lov FOR
823: SELECT cost_group
824: , cost_group_id
825: , description
826: FROM cst_cost_groups
827: WHERE organization_id = p_organization_id
828: AND cost_group LIKE (p_cost_group);
829: ELSE -- Dynamic entries are not allowed
830: OPEN x_cost_group_lov FOR

Line 834: FROM cst_cost_groups ccg, mtl_physical_inventory_tags mpit

830: OPEN x_cost_group_lov FOR
831: SELECT UNIQUE ccg.cost_group
832: , ccg.cost_group_id
833: , ccg.description
834: FROM cst_cost_groups ccg, mtl_physical_inventory_tags mpit
835: WHERE ccg.organization_id = p_organization_id
836: AND ccg.cost_group LIKE (p_cost_group)
837: AND ccg.cost_group_id = mpit.cost_group_id
838: AND mpit.physical_inventory_id = p_physical_inventory_id

Line 870: FROM cst_cost_groups

866: OPEN x_cost_group_lov FOR
867: SELECT cost_group
868: , cost_group_id
869: , description
870: FROM cst_cost_groups
871: WHERE organization_id = p_organization_id
872: AND cost_group LIKE (p_cost_group);
873: ELSE -- Unscheduled entries are not allowed
874: OPEN x_cost_group_lov FOR

Line 878: FROM cst_cost_groups ccg, mtl_cycle_count_entries mcce

874: OPEN x_cost_group_lov FOR
875: SELECT UNIQUE ccg.cost_group
876: , ccg.cost_group_id
877: , ccg.description
878: FROM cst_cost_groups ccg, mtl_cycle_count_entries mcce
879: WHERE ccg.organization_id = p_organization_id
880: AND ccg.cost_group LIKE (p_cost_group)
881: AND ccg.cost_group_id = mcce.cost_group_id
882: AND mcce.cycle_count_header_id = p_cycle_count_header_id

Line 1801: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq

1797: OPEN x_cost_group FOR
1798: SELECT DISTINCT ccg.cost_group
1799: , ccg.cost_group_id
1800: , ccg.description
1801: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq
1802: WHERE ccg.cost_group_id = moq.cost_group_id
1803: AND ccg.cost_group_type = 3
1804: AND NVL(ccg.organization_id, moq.organization_id) = moq.organization_id
1805: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))