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.CSP_SUPERSESSIONS_PVT dependencies on MTL_PARAMETERS

Line 36: FROM mtl_parameters

32:
33: CURSOR get_mster_org(c_organization_id NUMBER)
34: IS
35: SELECT master_organization_id
36: FROM mtl_parameters
37: WHERE organization_id = c_organization_id;
38:
39: PROCEDURE BUILD_NOT_IN_CONDITION(p_master_org NUMBER, p_inventory_item_id NUMBER, x_where_string OUT NOCOPY varchar2);
40: PROCEDURE parse_supply_chain(p_org_id IN NUMBER

Line 78: from csp_planning_parameters cpp,mtl_parameters mp

74: PROCEDURE get_item_supplied IS
75:
76: CURSOR get_master_organizations IS
77: select distinct(mp.MASTER_ORGANIZATION_ID)
78: from csp_planning_parameters cpp,mtl_parameters mp
79: where (cpp.ORGANIZATION_TYPE is not null or cpp.node_type = 'SUBINVENTORY')
80: and mp.ORGANIZATION_ID = cpp.ORGANIZATION_ID;
81:
82: CURSOR get_supersede_items(c_master_org_id number)

Line 94: FROM CSP_SUPPLY_CHAIN cscp, mtl_parameters mp

90:
91: /*CURSOR get_supply_chain(c_master_org_id number,c_inv_item_id number)
92: IS
93: SELECT cscp.ORGANIZATION_ID,decode(cscp.SECONDARY_INVENTORY,'-',null,cscp.SECONDARY_INVENTORY),SUPPLY_LEVEL
94: FROM CSP_SUPPLY_CHAIN cscp, mtl_parameters mp
95: WHERE mp.MASTER_ORGANIZATION_ID = c_master_org_id
96: and cscp.INVENTORY_ITEM_ID = c_inv_item_id
97: --and cscp.SUPPLY_LEVEL = 1
98: and cscp.organization_id = mp.organization_id

Line 104: FROM CSP_SUPPLY_CHAIN csc, mtl_parameters mp, csp_planning_parameters cpp

100:
101: CURSOR get_supply_chain(c_master_org_id number,c_inv_item_id number)
102: IS
103: SELECT DISTINCT csc.ORGANIZATION_ID,decode(csc.SECONDARY_INVENTORY,'-',null,csc.SECONDARY_INVENTORY),SUPPLY_LEVEL
104: FROM CSP_SUPPLY_CHAIN csc, mtl_parameters mp, csp_planning_parameters cpp
105: WHERE mp.MASTER_ORGANIZATION_ID = c_master_org_id
106: and csc.INVENTORY_ITEM_ID = c_inv_item_id
107: and csc.organization_id = mp.organization_id
108: and cpp.organization_id = csc.organization_id

Line 623: from csp_planning_parameters cpp,mtl_parameters mp

619: PROCEDURE get_item_planned IS
620:
621: CURSOR get_master_organizations IS
622: select distinct(mp.MASTER_ORGANIZATION_ID)
623: from csp_planning_parameters cpp,mtl_parameters mp
624: where cpp.NODE_TYPE IN('SUBINVENTORY','ORGANIZATION_WH')
625: and mp.ORGANIZATION_ID = cpp.ORGANIZATION_ID;
626:
627: CURSOR get_replaced_items(c_master_org_id number)

Line 646: FROM CSP_SUPPLY_CHAIN csc, mtl_parameters mp

642:
643: /* CURSOR get_central_warehouse(c_master_org_id number,c_inv_item_id number)
644: IS
645: SELECT DISTINCT csc.ORGANIZATION_ID,DECODE(csc.SECONDARY_INVENTORY,'-',NULL)
646: FROM CSP_SUPPLY_CHAIN csc, mtl_parameters mp
647: WHERE mp.MASTER_ORGANIZATION_ID = c_master_org_id
648: and csc.INVENTORY_ITEM_ID = c_inv_item_id
649: and csc.organization_id = mp.organization_id
650: and csc.SOURCE_ORGANIZATION_ID IS NULL;*/

Line 656: FROM CSP_SUPPLY_CHAIN csc, mtl_parameters mp, csp_planning_parameters cpp

652:
653: CURSOR get_central_warehouse(c_master_org_id number,c_inv_item_id number)
654: IS
655: SELECT DISTINCT csc.ORGANIZATION_ID,DECODE(csc.SECONDARY_INVENTORY,'-',NULL),csc.supply_level
656: FROM CSP_SUPPLY_CHAIN csc, mtl_parameters mp, csp_planning_parameters cpp
657: WHERE mp.MASTER_ORGANIZATION_ID = c_master_org_id
658: and csc.INVENTORY_ITEM_ID = c_inv_item_id
659: and csc.organization_id = mp.organization_id
660: and cpp.organization_id = csc.organization_id

Line 821: from mtl_related_items mri,mtl_parameters mp

817:
818:
819: CURSOR is_item_repairable_to_self IS
820: select decode(mri.inventory_item_id,p_item_id,'Y','N')
821: from mtl_related_items mri,mtl_parameters mp
822: where mp.organization_id = p_org_id
823: and mri.organization_id = mp.master_organization_id
824: and mri.inventory_item_id = p_item_id
825: and mri.RELATIONSHIP_TYPE_ID = 18;

Line 1148: FROM mtl_related_items mri, mtl_parameters mp, mtl_system_items_b msi

1144: IS
1145:
1146: CURSOR get_supersede_item(c_inventory_item_id NUMBER, c_organization_id NUMBER) IS
1147: SELECT mri.related_item_id
1148: FROM mtl_related_items mri, mtl_parameters mp, mtl_system_items_b msi
1149: WHERE mp.organization_id = c_organization_id
1150: AND mri.organization_id = mp.master_organization_id
1151: AND mri.inventory_item_id = c_inventory_item_id
1152: AND mri.RELATIONSHIP_TYPE_ID = 8

Line 1355: from csp_planning_parameters cpp, mtl_parameters mp

1351: l_return_status varchar2(3);
1352:
1353: CURSOR get_org_subinv IS
1354: select cpp.ORGANIZATION_ID, cpp.SECONDARY_INVENTORY, mp.master_organization_id
1355: from csp_planning_parameters cpp, mtl_parameters mp
1356: where cpp.level_id = p_level_id
1357: and mp.ORGANIZATION_ID = cpp.organization_id ;
1358:
1359: CURSOR get_supply_chain IS

Line 1436: from MTL_RELATED_ITEMS mriv, mtl_parameters mp

1432: l_supersede_items supersede_item_table_type;
1433:
1434: CURSOR get_supersede_item(p_item_id number, p_org_id number) IS
1435: select RELATED_ITEM_ID
1436: from MTL_RELATED_ITEMS mriv, mtl_parameters mp
1437: where mp.organization_id = p_org_id
1438: and mriv.inventory_item_id = p_item_id
1439: and mriv. organization_id = mp.master_organization_id
1440: and mriv.RELATIONSHIP_TYPE_ID = 8;