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 684: FROM cst_cost_groups

680: -- organization
681: /* SELECT cost_group
682: , cost_group_id
683: , description
684: FROM cst_cost_groups
685: WHERE cost_group LIKE (p_cost_group); */
686: select ccg.cost_group ,ccga.cost_group_id, ccg.description
687: from cst_cost_groups ccg, cst_cost_group_accounts ccga
688: where ccg.cost_group_id = ccga.cost_group_id

Line 687: from cst_cost_groups ccg, cst_cost_group_accounts ccga

683: , description
684: FROM cst_cost_groups
685: WHERE cost_group LIKE (p_cost_group); */
686: select ccg.cost_group ,ccga.cost_group_id, ccg.description
687: from cst_cost_groups ccg, cst_cost_group_accounts ccga
688: where ccg.cost_group_id = ccga.cost_group_id
689: and ccga.organization_id = nvl(p_organization_id, ccga.organization_id)
690: --WHERE organization_id = p_organization_id
691: and ccg.cost_group LIKE (p_cost_group);

Line 736: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq

732: OPEN x_cost_group_lov FOR
733: SELECT ccg.cost_group
734: , ccg.cost_group_id
735: , ccg.description
736: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq
737: WHERE ccg.cost_group LIKE (p_from_cost_group)
738: AND ccg.cost_group_id = moq.cost_group_id
739: AND ccg.cost_group_type <> 1 --PJM-WMS Integration
740: AND ((moq.revision = p_revision)

Line 757: FROM cst_cost_groups ccg, wms_lpn_contents wlc

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

Line 776: FROM cst_cost_groups ccg, cst_cost_group_accounts ccga

772: OPEN x_cost_group_lov FOR
773: SELECT ccg.cost_group
774: , ccg.cost_group_id
775: , ccg.description
776: FROM cst_cost_groups ccg, cst_cost_group_accounts ccga
777: WHERE ccg.cost_group LIKE (p_to_cost_group)
778: AND ccg.cost_group_id = ccga.cost_group_id
779: AND ccga.cost_group_id <> p_from_cost_group_id
780: AND ccg.cost_group_type <> 1 --PJM-WMS Integration

Line 804: FROM cst_cost_groups

800: OPEN x_cost_group_lov FOR
801: SELECT cost_group
802: , cost_group_id
803: , description
804: FROM cst_cost_groups
805: WHERE organization_id = p_organization_id
806: AND cost_group LIKE (p_cost_group);
807: ELSE -- Dynamic entries are not allowed
808: OPEN x_cost_group_lov FOR

Line 812: FROM cst_cost_groups ccg, mtl_physical_inventory_tags mpit

808: OPEN x_cost_group_lov FOR
809: SELECT UNIQUE ccg.cost_group
810: , ccg.cost_group_id
811: , ccg.description
812: FROM cst_cost_groups ccg, mtl_physical_inventory_tags mpit
813: WHERE ccg.organization_id = p_organization_id
814: AND ccg.cost_group LIKE (p_cost_group)
815: AND ccg.cost_group_id = mpit.cost_group_id
816: AND mpit.physical_inventory_id = p_physical_inventory_id

Line 848: FROM cst_cost_groups

844: OPEN x_cost_group_lov FOR
845: SELECT cost_group
846: , cost_group_id
847: , description
848: FROM cst_cost_groups
849: WHERE organization_id = p_organization_id
850: AND cost_group LIKE (p_cost_group);
851: ELSE -- Unscheduled entries are not allowed
852: OPEN x_cost_group_lov FOR

Line 856: FROM cst_cost_groups ccg, mtl_cycle_count_entries mcce

852: OPEN x_cost_group_lov FOR
853: SELECT UNIQUE ccg.cost_group
854: , ccg.cost_group_id
855: , ccg.description
856: FROM cst_cost_groups ccg, mtl_cycle_count_entries mcce
857: WHERE ccg.organization_id = p_organization_id
858: AND ccg.cost_group LIKE (p_cost_group)
859: AND ccg.cost_group_id = mcce.cost_group_id
860: AND mcce.cycle_count_header_id = p_cycle_count_header_id

Line 1777: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq

1773: OPEN x_cost_group FOR
1774: SELECT DISTINCT ccg.cost_group
1775: , ccg.cost_group_id
1776: , ccg.description
1777: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq
1778: WHERE ccg.cost_group_id = moq.cost_group_id
1779: AND ccg.cost_group_type = 3
1780: AND NVL(ccg.organization_id, moq.organization_id) = moq.organization_id
1781: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))