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 CSP_PLANNING_PARAMETERS

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 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 228: FROM CSP_SUPPLY_CHAIN csc,csp_planning_parameters cpp

224:
225: CURSOR get_sources(c_inv_item_id number,c_org_id number,c_secondary_inventory Varchar2,c_supply_level number)
226: IS
227: SELECT csc.SOURCE_ORGANIZATION_ID, decode(csc.SOURCE_SUBINVENTORY,'-',null),cpp.ORGANIZATION_TYPE
228: FROM CSP_SUPPLY_CHAIN csc,csp_planning_parameters cpp
229: WHERE cpp.organization_id = c_org_id
230: and (cpp.ORGANIZATION_TYPE IS NOT null or cpp.node_type = 'SUBINVENTORY')
231: and cpp.secondary_inventory = nvl(c_secondary_inventory,cpp.secondary_inventory)
232: and csc.INVENTORY_ITEM_ID = c_inv_item_id

Line 444: FROM CSP_SUPPLY_CHAIN csc,csp_planning_parameters cpp

440:
441: CURSOR get_supply_level_in_SC(c_inv_item_id number,c_org_id number,c_secondary_inventory Varchar2,c_supply_level number)
442: IS
443: SELECT csc.ORGANIZATION_ID,decode(csc.SECONDARY_INVENTORY,'-',null,csc.SECONDARY_INVENTORY) ,csc.SOURCE_ORGANIZATION_ID, decode(csc.SOURCE_SUBINVENTORY,'-',null,csc.SOURCE_SUBINVENTORY)
444: FROM CSP_SUPPLY_CHAIN csc,csp_planning_parameters cpp
445: WHERE cpp.organization_id = c_org_id
446: and (cpp.ORGANIZATION_TYPE IS NOT null or cpp.node_type = 'SUBINVENTORY')
447: and cpp.secondary_inventory = nvl(c_secondary_inventory,cpp.secondary_inventory)
448: and csc.INVENTORY_ITEM_ID = c_inv_item_id

Line 456: FROM CSP_SUPPLY_CHAIN csc,csp_planning_parameters cpp

452:
453: CURSOR get_supply_chain(c_inv_item_id number,c_org_id number,c_secondary_inventory Varchar2,c_supply_level number)
454: IS
455: SELECT csc.ORGANIZATION_ID,decode(csc.SECONDARY_INVENTORY,'-',null,csc.SECONDARY_INVENTORY),csc.SUPPLY_LEVEL
456: FROM CSP_SUPPLY_CHAIN csc,csp_planning_parameters cpp
457: WHERE cpp.organization_id = c_org_id
458: and (cpp.ORGANIZATION_TYPE IS NOT null or cpp.node_type = 'SUBINVENTORY')
459: and cpp.secondary_inventory = nvl(c_secondary_inventory,cpp.secondary_inventory)
460: and csc.INVENTORY_ITEM_ID = c_inv_item_id

Line 468: FROM CSP_SUPPLY_CHAIN csc,csp_planning_parameters cpp

464:
465: CURSOR get_sources(c_inv_item_id number,c_org_id number,c_secondary_inventory Varchar2,c_supply_level number)
466: IS
467: SELECT csc.SOURCE_ORGANIZATION_ID, decode(csc.SOURCE_SUBINVENTORY,'-',null)
468: FROM CSP_SUPPLY_CHAIN csc,csp_planning_parameters cpp
469: WHERE cpp.organization_id = c_org_id
470: and (cpp.ORGANIZATION_TYPE IS NOT null or cpp.node_type = 'SUBINVENTORY')
471: and cpp.secondary_inventory = nvl(c_secondary_inventory,cpp.secondary_inventory)
472: and csc.INVENTORY_ITEM_ID = c_inv_item_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 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 810: from csp_planning_parameters cpp, mrp_sources_V msv

806:
807: CURSOR get_defective_sources
808: IS
809: select msv.source_organization_id,NULL
810: from csp_planning_parameters cpp, mrp_sources_V msv
811: where cpp.organization_id = p_org_id
812: and cpp.NODE_TYPE = 'ORGANIZATION_WH'
813: and msv.assignment_set_id = cpp.DEFECTIVE_ASSIGNMENT_SET_ID
814: and msv.inventory_item_id = l_item_id

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