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_PLAN_REORDERS

Line 207: from mtl_system_items_b msib, csp_plan_reorders cpr

203:
204: CURSOR get_rop_for_org
205: IS
206: SELECT nvl(decode(cpr.newbuy_rop,0,null), NVL(MIN_MINMAX_QUANTITY,0))
207: from mtl_system_items_b msib, csp_plan_reorders cpr
208: where msib.organization_id = p_planned_org_id
209: and msib.inventory_item_id = l_inventory_item_Id
210: and cpr.organization_id = msib.organization_id
211: and cpr.inventory_item_id = msib.inventory_item_id ;

Line 682: from mtl_system_items_b msib, csp_plan_reorders cpr

678: from mtl_system_items_b
679: where organization_id = c_org_id
680: and inventory_item_id = c_item_id;*/
681: SELECT nvl(decode(cpr.newbuy_rop,0,null), NVL(MIN_MINMAX_QUANTITY,0))
682: from mtl_system_items_b msib, csp_plan_reorders cpr
683: where msib.organization_id = c_org_id
684: and msib.inventory_item_id = c_item_id
685: and cpr.organization_id = msib.organization_id
686: and cpr.inventory_item_id = msib.inventory_item_id ;

Line 793: from mtl_system_items_b msib, csp_plan_reorders cpr

789: from mtl_system_items_b
790: where organization_id = p_org_id
791: and inventory_item_id = p_item_id;*/
792: SELECT nvl(decode(cpr.newbuy_rop,0,null), NVL(MIN_MINMAX_QUANTITY,0))
793: from mtl_system_items_b msib, csp_plan_reorders cpr
794: where msib.organization_id = p_org_id
795: and msib.inventory_item_id = p_item_id
796: and cpr.organization_id = msib.organization_id
797: and cpr.inventory_item_id = msib.inventory_item_id ;