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_PLAN_DETAILS_PKG dependencies on CSP_PLAN_REORDERS

Line 570: delete from csp_plan_reorders

566:
567: procedure reorders(p_organization_id number,p_inventory_item_id number) is
568: begin
569:
570: delete from csp_plan_reorders
571: where organization_id = p_organization_id
572: and inventory_item_id = nvl(p_inventory_item_id,inventory_item_id);
573:
574: insert into csp_plan_reorders(

Line 574: insert into csp_plan_reorders(

570: delete from csp_plan_reorders
571: where organization_id = p_organization_id
572: and inventory_item_id = nvl(p_inventory_item_id,inventory_item_id);
573:
574: insert into csp_plan_reorders(
575: inventory_item_id,
576: organization_id,
577: excess_rop,
578: repair_rop,

Line 1801: csp_plan_reorders cpr

1797: fnd_global.user_id,
1798: sysdate,
1799: fnd_global.login_id
1800: from csp_plan_details cpd,
1801: csp_plan_reorders cpr
1802: where cpd.plan_detail_type in ('1','1000','2000','4110','4210','4310','4220')
1803: and cpr.organization_id (+) = cpd.organization_id
1804: and cpr.inventory_item_id (+) = cpd.inventory_item_id
1805: and cpd.organization_id = nvl(l_organization_id,cpd.organization_id)

Line 1874: csp_plan_reorders cpr,

1870: fnd_global.user_id,
1871: sysdate,
1872: fnd_global.login_id
1873: from csp_plan_details cpd,
1874: csp_plan_reorders cpr,
1875: csp_item_pl_params cipp
1876: where cpd.organization_id = l_organization_id
1877: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
1878: and cpd.plan_detail_type in ('1','2000','2300')

Line 1945: csp_plan_reorders cpr

1941: fnd_global.user_id,
1942: sysdate,
1943: fnd_global.login_id
1944: from csp_plan_details cpd,
1945: csp_plan_reorders cpr
1946: where cpd.organization_id = l_organization_id
1947: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
1948: and cpd.plan_detail_type in ('2300','8110','4110','9001')
1949: and cpd.quantity > 0

Line 1995: csp_plan_reorders cpr

1991: fnd_global.user_id,
1992: sysdate,
1993: fnd_global.login_id
1994: from csp_plan_details cpd,
1995: csp_plan_reorders cpr
1996: where cpd.organization_id = l_organization_id
1997: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
1998: and cpd.plan_detail_type in ('2100','2200','8120','8210','9001')
1999: and cpd.quantity > 0

Line 2045: csp_plan_reorders cpr

2041: fnd_global.user_id,
2042: sysdate,
2043: fnd_global.login_id
2044: from csp_plan_details cpd,
2045: csp_plan_reorders cpr
2046: where cpd.organization_id = l_organization_id
2047: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
2048: and cpd.plan_detail_type in ('4100','2200','8120','8210','9001')
2049: and cpd.quantity > 0

Line 2113: csp_plan_reorders cpr

2109: fnd_global.user_id,
2110: sysdate,
2111: fnd_global.login_id
2112: from csp_plan_details cpd,
2113: csp_plan_reorders cpr
2114: where cpd.organization_id = l_organization_id
2115: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
2116: and cpd.plan_detail_type in ('4200','2300','8110','8210','9002','9003')
2117: and cpd.quantity > 0

Line 2188: csp_plan_reorders cpr,

2184: fnd_global.user_id,
2185: sysdate,
2186: fnd_global.login_id
2187: from csp_plan_details cpd,
2188: csp_plan_reorders cpr,
2189: csp_item_pl_params cipp
2190: where cpd.organization_id = l_organization_id
2191: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
2192: and cpd.plan_detail_type in ('1','2000','2200','8110')

Line 2262: csp_plan_reorders cpr

2258: fnd_global.user_id,
2259: sysdate,
2260: fnd_global.login_id
2261: from csp_plan_details cpd,
2262: csp_plan_reorders cpr
2263: where cpd.organization_id = l_organization_id
2264: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
2265: and cpd.plan_detail_type = l_onhand_type_in
2266: and cpd.quantity < decode(l_onhand_condition_in,

Line 2317: csp_plan_reorders cpr

2313: fnd_global.user_id,
2314: sysdate,
2315: fnd_global.login_id
2316: from csp_plan_details cpd,
2317: csp_plan_reorders cpr
2318: where cpd.organization_id = l_organization_id
2319: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
2320: and cpd.plan_detail_type = l_onhand_type_in
2321: and cpd.quantity < decode(l_onhand_condition_in,

Line 2365: csp_plan_reorders cpr,

2361: fnd_global.user_id,
2362: sysdate,
2363: fnd_global.login_id
2364: from csp_plan_details cpd,
2365: csp_plan_reorders cpr,
2366: cst_item_costs cic,
2367: mtl_parameters mp
2368: where cpd.organization_id = l_organization_id
2369: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)

Line 2435: csp_plan_reorders cpr

2431: fnd_global.user_id,
2432: sysdate,
2433: fnd_global.login_id
2434: from csp_plan_details cpd,
2435: csp_plan_reorders cpr
2436: where cpd.organization_id = l_organization_id
2437: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
2438: and cpd.quantity > 0
2439: and cpd.plan_detail_type in ('1','2000','2100','8110','8120')

Line 2515: csp_plan_reorders cpr,

2511: fnd_global.user_id,
2512: sysdate,
2513: fnd_global.login_id
2514: from MRP_ITEM_SOURCING_LEVELS_V mislv,
2515: csp_plan_reorders cpr,
2516: csp_plan_details cpd
2517: where mislv.organization_id = l_organization_id
2518: and mislv.assignment_set_id = l_usable_assignment_set_id
2519: and mislv.inventory_item_id = cpd.inventory_item_id

Line 2692: csp_plan_reorders cpr

2688: 'REPAIR_FORECAST',cpr.repair_edq) edq_quantity,
2689: trunc(cpd.plan_date) plan_date,
2690: cpr.newbuy_safety_stock - cpr.repair_safety_stock
2691: from csp_plan_details cpd,
2692: csp_plan_reorders cpr
2693: where cpd.organization_id = nvl(l_organization_id,cpd.organization_id)
2694: and cpd.inventory_item_id = p_inventory_item_id
2695: and cpr.organization_id(+) = cpd.organization_id
2696: and cpr.inventory_item_id(+) = cpd.inventory_item_id

Line 2735: from csp_plan_reorders cpr,

2731: select null,
2732: sum(nvl(decode(cpd.plan_detail_type,'4220',cpd.quantity*-1,cpd.quantity),0)),
2733: cpr.repair_edq,
2734: null
2735: from csp_plan_reorders cpr,
2736: csp_plan_details cpd
2737: where cpr.organization_id = l_organization_id
2738: and cpr.inventory_item_id = p_inventory_item_id
2739: and cpd.organization_id = cpr.organization_id

Line 2753: csp_plan_reorders cpr

2749: cpr.newbuy_edq,
2750: null
2751: from mtl_system_items_b msib,
2752: mtl_parameters mp,
2753: csp_plan_reorders cpr
2754: where msib.organization_id = l_organization_id
2755: and msib.inventory_item_id = p_inventory_item_id
2756: and mp.organization_id = msib.organization_id
2757: and cpr.organization_id = msib.organization_id

Line 3165: csp_plan_reorders cpr

3161: fnd_global.user_id,
3162: sysdate,
3163: fnd_global.login_id
3164: from mtl_system_items_b msib,
3165: csp_plan_reorders cpr
3166: where msib.organization_id = l_organization_id
3167: and msib.inventory_item_id = nvl(l_inventory_item_id,msib.inventory_item_id)
3168: and cpr.organization_id(+) = msib.organization_id
3169: and cpr.inventory_item_id(+) = msib.inventory_item_id

Line 3372: csp_plan_reorders cpr,

3368: sysdate,
3369: fnd_global.login_id
3370: from csp_plan_details cpd,
3371: csp_planning_parameters cpp,
3372: csp_plan_reorders cpr,
3373: csp_plan_leadtimes cpl,
3374: csp_item_pl_params cipp
3375: where cpd.plan_detail_type = '1'
3376: and cpd.organization_id = p_organization_id