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_VALIDATE_PUB

Line 2496: nvl(csp_validate_pub.get_avail_qty(mislv.source_organization_id,null,null,mislv.inventory_item_id),0),

2492: select min('9001'),
2493: null,
2494: null,
2495: mislv.source_organization_id,
2496: nvl(csp_validate_pub.get_avail_qty(mislv.source_organization_id,null,null,mislv.inventory_item_id),0),
2497: greatest(0,nvl(csp_validate_pub.get_available_qty,0)
2498: - greatest(nvl(cpr.newbuy_rop,0)+nvl(cpr.newbuy_edq,0),
2499: nvl(cpr.repair_rop,0)+nvl(cpr.repair_edq,0),
2500: nvl(cpr.excess_rop,0)+nvl(cpr.excess_edq,0))),

Line 2497: greatest(0,nvl(csp_validate_pub.get_available_qty,0)

2493: null,
2494: null,
2495: mislv.source_organization_id,
2496: nvl(csp_validate_pub.get_avail_qty(mislv.source_organization_id,null,null,mislv.inventory_item_id),0),
2497: greatest(0,nvl(csp_validate_pub.get_available_qty,0)
2498: - greatest(nvl(cpr.newbuy_rop,0)+nvl(cpr.newbuy_edq,0),
2499: nvl(cpr.repair_rop,0)+nvl(cpr.repair_edq,0),
2500: nvl(cpr.excess_rop,0)+nvl(cpr.excess_edq,0))),
2501: nvl(csp_validate_pub.get_onhand_qty,0),

Line 2501: nvl(csp_validate_pub.get_onhand_qty,0),

2497: greatest(0,nvl(csp_validate_pub.get_available_qty,0)
2498: - greatest(nvl(cpr.newbuy_rop,0)+nvl(cpr.newbuy_edq,0),
2499: nvl(cpr.repair_rop,0)+nvl(cpr.repair_edq,0),
2500: nvl(cpr.excess_rop,0)+nvl(cpr.excess_edq,0))),
2501: nvl(csp_validate_pub.get_onhand_qty,0),
2502: greatest(0,nvl(csp_validate_pub.get_available_qty,0)
2503: - greatest(nvl(cpr.newbuy_rop,0)+nvl(cpr.newbuy_edq,0),
2504: nvl(cpr.repair_rop,0)+nvl(cpr.repair_edq,0),
2505: nvl(cpr.excess_rop,0)+nvl(cpr.excess_edq,0))),

Line 2502: greatest(0,nvl(csp_validate_pub.get_available_qty,0)

2498: - greatest(nvl(cpr.newbuy_rop,0)+nvl(cpr.newbuy_edq,0),
2499: nvl(cpr.repair_rop,0)+nvl(cpr.repair_edq,0),
2500: nvl(cpr.excess_rop,0)+nvl(cpr.excess_edq,0))),
2501: nvl(csp_validate_pub.get_onhand_qty,0),
2502: greatest(0,nvl(csp_validate_pub.get_available_qty,0)
2503: - greatest(nvl(cpr.newbuy_rop,0)+nvl(cpr.newbuy_edq,0),
2504: nvl(cpr.repair_rop,0)+nvl(cpr.repair_edq,0),
2505: nvl(cpr.excess_rop,0)+nvl(cpr.excess_edq,0))),
2506: min(trunc(sysdate)),

Line 2564: nvl(csp_validate_pub.get_avail_qty(mislv.source_organization_id,null,null,mislv.inventory_item_id),0),

2560: select '9002',
2561: null,
2562: null,
2563: mislv.source_organization_id,
2564: nvl(csp_validate_pub.get_avail_qty(mislv.source_organization_id,null,null,mislv.inventory_item_id),0),
2565: nvl(csp_validate_pub.get_onhand_qty,0),
2566: nvl(csp_validate_pub.get_available_qty,0),
2567: trunc(sysdate),
2568: mislv.inventory_item_id,

Line 2565: nvl(csp_validate_pub.get_onhand_qty,0),

2561: null,
2562: null,
2563: mislv.source_organization_id,
2564: nvl(csp_validate_pub.get_avail_qty(mislv.source_organization_id,null,null,mislv.inventory_item_id),0),
2565: nvl(csp_validate_pub.get_onhand_qty,0),
2566: nvl(csp_validate_pub.get_available_qty,0),
2567: trunc(sysdate),
2568: mislv.inventory_item_id,
2569: cpd.organization_id,

Line 2566: nvl(csp_validate_pub.get_available_qty,0),

2562: null,
2563: mislv.source_organization_id,
2564: nvl(csp_validate_pub.get_avail_qty(mislv.source_organization_id,null,null,mislv.inventory_item_id),0),
2565: nvl(csp_validate_pub.get_onhand_qty,0),
2566: nvl(csp_validate_pub.get_available_qty,0),
2567: trunc(sysdate),
2568: mislv.inventory_item_id,
2569: cpd.organization_id,
2570: fnd_global.user_id,

Line 2607: nvl(csp_validate_pub.get_avail_qty(mislv.source_organization_id,null,null,mri.inventory_item_id),0),

2603: select '9003',
2604: null,
2605: null,
2606: mislv.source_organization_id,
2607: nvl(csp_validate_pub.get_avail_qty(mislv.source_organization_id,null,null,mri.inventory_item_id),0),
2608: nvl(csp_validate_pub.get_onhand_qty,0),
2609: nvl(csp_validate_pub.get_available_qty,0),
2610: trunc(sysdate),
2611: mri.related_item_id,

Line 2608: nvl(csp_validate_pub.get_onhand_qty,0),

2604: null,
2605: null,
2606: mislv.source_organization_id,
2607: nvl(csp_validate_pub.get_avail_qty(mislv.source_organization_id,null,null,mri.inventory_item_id),0),
2608: nvl(csp_validate_pub.get_onhand_qty,0),
2609: nvl(csp_validate_pub.get_available_qty,0),
2610: trunc(sysdate),
2611: mri.related_item_id,
2612: cpd.organization_id,

Line 2609: nvl(csp_validate_pub.get_available_qty,0),

2605: null,
2606: mislv.source_organization_id,
2607: nvl(csp_validate_pub.get_avail_qty(mislv.source_organization_id,null,null,mri.inventory_item_id),0),
2608: nvl(csp_validate_pub.get_onhand_qty,0),
2609: nvl(csp_validate_pub.get_available_qty,0),
2610: trunc(sysdate),
2611: mri.related_item_id,
2612: cpd.organization_id,
2613: mri.inventory_item_id,

Line 3147: nvl(csp_validate_pub.get_avail_qty(msib.organization_id,null,null,msib.inventory_item_id),0),

3143: select '1',
3144: '0',
3145: null,
3146: null,
3147: nvl(csp_validate_pub.get_avail_qty(msib.organization_id,null,null,msib.inventory_item_id),0),
3148: nvl(csp_validate_pub.get_onhand_qty,0),
3149: greatest(0,nvl(csp_validate_pub.get_available_qty,0)
3150: - greatest(nvl(cpr.newbuy_rop,0)+nvl(cpr.newbuy_edq,0),
3151: nvl(cpr.repair_rop,0)+nvl(cpr.repair_edq,0),

Line 3148: nvl(csp_validate_pub.get_onhand_qty,0),

3144: '0',
3145: null,
3146: null,
3147: nvl(csp_validate_pub.get_avail_qty(msib.organization_id,null,null,msib.inventory_item_id),0),
3148: nvl(csp_validate_pub.get_onhand_qty,0),
3149: greatest(0,nvl(csp_validate_pub.get_available_qty,0)
3150: - greatest(nvl(cpr.newbuy_rop,0)+nvl(cpr.newbuy_edq,0),
3151: nvl(cpr.repair_rop,0)+nvl(cpr.repair_edq,0),
3152: nvl(cpr.excess_rop,0)+nvl(cpr.excess_edq,0))),

Line 3149: greatest(0,nvl(csp_validate_pub.get_available_qty,0)

3145: null,
3146: null,
3147: nvl(csp_validate_pub.get_avail_qty(msib.organization_id,null,null,msib.inventory_item_id),0),
3148: nvl(csp_validate_pub.get_onhand_qty,0),
3149: greatest(0,nvl(csp_validate_pub.get_available_qty,0)
3150: - greatest(nvl(cpr.newbuy_rop,0)+nvl(cpr.newbuy_edq,0),
3151: nvl(cpr.repair_rop,0)+nvl(cpr.repair_edq,0),
3152: nvl(cpr.excess_rop,0)+nvl(cpr.excess_edq,0))),
3153: nvl(csp_validate_pub.get_onhand_qty,0),

Line 3153: nvl(csp_validate_pub.get_onhand_qty,0),

3149: greatest(0,nvl(csp_validate_pub.get_available_qty,0)
3150: - greatest(nvl(cpr.newbuy_rop,0)+nvl(cpr.newbuy_edq,0),
3151: nvl(cpr.repair_rop,0)+nvl(cpr.repair_edq,0),
3152: nvl(cpr.excess_rop,0)+nvl(cpr.excess_edq,0))),
3153: nvl(csp_validate_pub.get_onhand_qty,0),
3154: trunc(sysdate),
3155: msib.inventory_item_id,
3156: l_organization_id,
3157: l_orig_period_size,