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_SUPPLY_CHAIN

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 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 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 843: from csp_supersede_items csi,csp_supply_chain csc

839: and csi.condition_type <> 'B';
840:
841: cursor get_source_planned_item IS
842: select csi.item_supplied,csc.source_organization_id,csc.supply_level,csc.source_subinventory
843: from csp_supersede_items csi,csp_supply_chain csc
844: where csc.organization_id= l_previou_source_org_id
845: and csc.secondary_inventory = nvl(l_source_subinv_code,'-')
846: and csc.inventory_item_id = l_item_id
847: and csc.supply_level = l_supply_level

Line 1361: from csp_supply_chain

1357: and mp.ORGANIZATION_ID = cpp.organization_id ;
1358:
1359: CURSOR get_supply_chain IS
1360: select inventory_item_id,supply_level, SOURCE_ORGANIZATION_ID,supply_chain_id
1361: from csp_supply_chain
1362: where organization_id = l_organization_id
1363: and secondary_inventory = l_subinv_code;
1364:
1365: