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_AUTO_ASLMSL_PVT dependencies on FND_GLOBAL

Line 14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSP_AUTO_ASLMSL_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cspvaslb.pls';
13:
14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
16: G_TOP_NODE_ID NUMBER := 0;
17: G_PRODUCT_ORGANIZATION NUMBER := Fnd_Profile.Value('ASO_PRODUCT_ORGANIZATION_ID');
18: G_USAGE_DATA NUMBER;

Line 15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSP_AUTO_ASLMSL_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cspvaslb.pls';
13:
14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
16: G_TOP_NODE_ID NUMBER := 0;
17: G_PRODUCT_ORGANIZATION NUMBER := Fnd_Profile.Value('ASO_PRODUCT_ORGANIZATION_ID');
18: G_USAGE_DATA NUMBER;
19: G_FORECAST_DATA NUMBER;

Line 428: fnd_global.user_id,

424: NULL,
425: 'O',
426: 'N',
427: sysdate,
428: fnd_global.user_id,
429: sysdate,
430: fnd_global.user_id,
431: fnd_global.conc_login_id
432: From CSP_PLANNING_PARAMETERS cpp,

Line 430: fnd_global.user_id,

426: 'N',
427: sysdate,
428: fnd_global.user_id,
429: sysdate,
430: fnd_global.user_id,
431: fnd_global.conc_login_id
432: From CSP_PLANNING_PARAMETERS cpp,
433: MTL_ITEM_SUB_INVENTORIES mis,
434: CST_ITEM_COSTS cic,

Line 431: fnd_global.conc_login_id

427: sysdate,
428: fnd_global.user_id,
429: sysdate,
430: fnd_global.user_id,
431: fnd_global.conc_login_id
432: From CSP_PLANNING_PARAMETERS cpp,
433: MTL_ITEM_SUB_INVENTORIES mis,
434: CST_ITEM_COSTS cic,
435: MTL_PARAMETERS mp

Line 485: fnd_global.user_id,

481: NULL,
482: 'O',
483: 'N',
484: sysdate,
485: fnd_global.user_id,
486: sysdate,
487: fnd_global.user_id,
488: fnd_global.conc_login_id
489: From CSP_PLANNING_PARAMETERS cpp,

Line 487: fnd_global.user_id,

483: 'N',
484: sysdate,
485: fnd_global.user_id,
486: sysdate,
487: fnd_global.user_id,
488: fnd_global.conc_login_id
489: From CSP_PLANNING_PARAMETERS cpp,
490: MTL_SYSTEM_ITEMS msi,
491: CST_ITEM_COSTS cic,

Line 488: fnd_global.conc_login_id

484: sysdate,
485: fnd_global.user_id,
486: sysdate,
487: fnd_global.user_id,
488: fnd_global.conc_login_id
489: From CSP_PLANNING_PARAMETERS cpp,
490: MTL_SYSTEM_ITEMS msi,
491: CST_ITEM_COSTS cic,
492: MTL_PARAMETERS mp

Line 562: fnd_global.user_id,

558: 'O',
559: 'N',
560: cpp.planning_parameters_id,
561: sysdate,
562: fnd_global.user_id,
563: sysdate,
564: fnd_global.user_id,
565: fnd_global.conc_login_id
566: from csp_planning_parameters cpp,

Line 564: fnd_global.user_id,

560: cpp.planning_parameters_id,
561: sysdate,
562: fnd_global.user_id,
563: sysdate,
564: fnd_global.user_id,
565: fnd_global.conc_login_id
566: from csp_planning_parameters cpp,
567: csp_usage_headers cuh,
568: cst_item_costs cic,

Line 565: fnd_global.conc_login_id

561: sysdate,
562: fnd_global.user_id,
563: sysdate,
564: fnd_global.user_id,
565: fnd_global.conc_login_id
566: from csp_planning_parameters cpp,
567: csp_usage_headers cuh,
568: cst_item_costs cic,
569: mtl_parameters mp,

Line 1523: fnd_global.user_id, sysdate,

1519: period_start_date,
1520: quantity,
1521: history_data_type)
1522: VALUES ( csp_usage_histories_s1.nextval,
1523: fnd_global.user_id, sysdate,
1524: fnd_global.user_id,sysdate,
1525: l_Prev_Rec.Inventory_Item_id,
1526: l_Prev_Rec.Organization_id,
1527: l_Prev_Rec.Subinventory_code,

Line 1524: fnd_global.user_id,sysdate,

1520: quantity,
1521: history_data_type)
1522: VALUES ( csp_usage_histories_s1.nextval,
1523: fnd_global.user_id, sysdate,
1524: fnd_global.user_id,sysdate,
1525: l_Prev_Rec.Inventory_Item_id,
1526: l_Prev_Rec.Organization_id,
1527: l_Prev_Rec.Subinventory_code,
1528: 3,

Line 1582: fnd_global.user_id,

1578: 'N',
1579: NULL,
1580: NULL,
1581: SYSDATE,
1582: fnd_global.user_id,
1583: SYSDATE,
1584: fnd_global.user_id,
1585: fnd_global.conc_login_id);
1586: End If;

Line 1584: fnd_global.user_id,

1580: NULL,
1581: SYSDATE,
1582: fnd_global.user_id,
1583: SYSDATE,
1584: fnd_global.user_id,
1585: fnd_global.conc_login_id);
1586: End If;
1587: l_count := 0;
1588: l_Usage_Quantity := 0;

Line 1585: fnd_global.conc_login_id);

1581: SYSDATE,
1582: fnd_global.user_id,
1583: SYSDATE,
1584: fnd_global.user_id,
1585: fnd_global.conc_login_id);
1586: End If;
1587: l_count := 0;
1588: l_Usage_Quantity := 0;
1589: l_Forecast_Quantity := 0;

Line 1735: fnd_global.user_id,

1731: nvl(manual_failure_rate,calculated_failure_rate),
1732: 'O',
1733: 'N',
1734: sysdate,
1735: fnd_global.user_id,
1736: sysdate,
1737: fnd_global.user_id,
1738: fnd_global.conc_login_id
1739: from csp_product_populations_fr_v cppf,

Line 1737: fnd_global.user_id,

1733: 'N',
1734: sysdate,
1735: fnd_global.user_id,
1736: sysdate,
1737: fnd_global.user_id,
1738: fnd_global.conc_login_id
1739: from csp_product_populations_fr_v cppf,
1740: csp_supersede_items csi
1741: where cppf.level_id like p_level_id || '%'

Line 1738: fnd_global.conc_login_id

1734: sysdate,
1735: fnd_global.user_id,
1736: sysdate,
1737: fnd_global.user_id,
1738: fnd_global.conc_login_id
1739: from csp_product_populations_fr_v cppf,
1740: csp_supersede_items csi
1741: where cppf.level_id like p_level_id || '%'
1742: and cppf.node_type in ('ORGANIZATION_WH','SUBINVENTORY')

Line 1868: fnd_global.user_id,

1864: cnpp.calculated_failure_rate),
1865: 'O',
1866: 'N',
1867: sysdate,
1868: fnd_global.user_id,
1869: sysdate,
1870: fnd_global.user_id,
1871: fnd_global.conc_login_id
1872: from csp_new_product_planning_v cnpp,

Line 1870: fnd_global.user_id,

1866: 'N',
1867: sysdate,
1868: fnd_global.user_id,
1869: sysdate,
1870: fnd_global.user_id,
1871: fnd_global.conc_login_id
1872: from csp_new_product_planning_v cnpp,
1873: csp_supersede_items csi
1874: where cnpp.level_id like p_level_id || '%'

Line 1871: fnd_global.conc_login_id

1867: sysdate,
1868: fnd_global.user_id,
1869: sysdate,
1870: fnd_global.user_id,
1871: fnd_global.conc_login_id
1872: from csp_new_product_planning_v cnpp,
1873: csp_supersede_items csi
1874: where cnpp.level_id like p_level_id || '%'
1875: and csi.inventory_item_id(+) = cnpp.inventory_item_id

Line 1997: fnd_global.user_id,

1993: curos.awu,
1994: 'O',
1995: 'N',
1996: sysdate,
1997: fnd_global.user_id,
1998: sysdate,
1999: fnd_global.user_id,
2000: fnd_global.conc_login_id
2001: from csp_usage_reg_org_subinv_v curos,

Line 1999: fnd_global.user_id,

1995: 'N',
1996: sysdate,
1997: fnd_global.user_id,
1998: sysdate,
1999: fnd_global.user_id,
2000: fnd_global.conc_login_id
2001: from csp_usage_reg_org_subinv_v curos,
2002: csp_supersede_items csi
2003: where curos.level_id like p_level_id || '%'

Line 2000: fnd_global.conc_login_id

1996: sysdate,
1997: fnd_global.user_id,
1998: sysdate,
1999: fnd_global.user_id,
2000: fnd_global.conc_login_id
2001: from csp_usage_reg_org_subinv_v curos,
2002: csp_supersede_items csi
2003: where curos.level_id like p_level_id || '%'
2004: and csi.inventory_item_id (+) = curos.inventory_item_id

Line 2165: fnd_global.user_id,

2161: cri.inventory_item_id,
2162: NULL,
2163: 1, -- supply_level
2164: sysdate,
2165: fnd_global.user_id,
2166: fnd_global.user_id,
2167: sysdate
2168: from csp_region_items_v cri,
2169: mtl_related_items mri,

Line 2166: fnd_global.user_id,

2162: NULL,
2163: 1, -- supply_level
2164: sysdate,
2165: fnd_global.user_id,
2166: fnd_global.user_id,
2167: sysdate
2168: from csp_region_items_v cri,
2169: mtl_related_items mri,
2170: mtl_parameters mp,

Line 2217: fnd_global.user_id,

2213: csc.inventory_item_id,
2214: NULL,
2215: l_supply_level,
2216: sysdate,
2217: fnd_global.user_id,
2218: fnd_global.user_id,
2219: sysdate
2220: from mtl_parameters mp,
2221: mtl_system_items_b msib,

Line 2218: fnd_global.user_id,

2214: NULL,
2215: l_supply_level,
2216: sysdate,
2217: fnd_global.user_id,
2218: fnd_global.user_id,
2219: sysdate
2220: from mtl_parameters mp,
2221: mtl_system_items_b msib,
2222: mtl_item_sub_inventories misi,

Line 2395: fnd_global.user_id,

2391: nvl(msi.preprocessing_lead_time,0) + nvl(msi.processing_lead_time,0) + nvl(msi.postprocessing_lead_time,0), nvl(msib.preprocessing_lead_time,0) + nvl(msib.full_lead_time,0) + nvl(msib.postprocessing_lead_time,0)),
2392: nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0))) lead_time,
2393: 1, -- supply_level
2394: sysdate,
2395: fnd_global.user_id,
2396: fnd_global.user_id,
2397: sysdate
2398: from mtl_parameters mp,
2399: mtl_system_items_b msib,

Line 2396: fnd_global.user_id,

2392: nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0))) lead_time,
2393: 1, -- supply_level
2394: sysdate,
2395: fnd_global.user_id,
2396: fnd_global.user_id,
2397: sysdate
2398: from mtl_parameters mp,
2399: mtl_system_items_b msib,
2400: mtl_item_sub_inventories misi,

Line 2430: fnd_global.user_id,

2426: nvl(msi.preprocessing_lead_time,0) + nvl(msi.processing_lead_time,0) + nvl(msi.postprocessing_lead_time,0), nvl(msib.preprocessing_lead_time,0) + nvl(msib.full_lead_time,0) + nvl(msib.postprocessing_lead_time,0)),
2427: nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0))) ,
2428: 1,
2429: sysdate,
2430: fnd_global.user_id,
2431: fnd_global.user_id,
2432: sysdate;
2433:
2434: loop

Line 2431: fnd_global.user_id,

2427: nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0))) ,
2428: 1,
2429: sysdate,
2430: fnd_global.user_id,
2431: fnd_global.user_id,
2432: sysdate;
2433:
2434: loop
2435: l_supply_level := l_supply_level + 1;

Line 2461: fnd_global.user_id,

2457: decode(nvl(msib.preprocessing_lead_time,0) + nvl(msib.full_lead_time,0) + nvl(msib.postprocessing_lead_time,0),0, nvl(msi.preprocessing_lead_time,0) + nvl(msi.processing_lead_time,0) + nvl(msi.postprocessing_lead_time,0),
2458: nvl(msib.preprocessing_lead_time,0) + nvl(msib.full_lead_time,0) + nvl(msib.postprocessing_lead_time,0)), nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0))) lead_time,
2459: l_supply_level,
2460: sysdate,
2461: fnd_global.user_id,
2462: fnd_global.user_id,
2463: sysdate
2464: from mtl_parameters mp,
2465: mtl_system_items_b msib,

Line 2462: fnd_global.user_id,

2458: nvl(msib.preprocessing_lead_time,0) + nvl(msib.full_lead_time,0) + nvl(msib.postprocessing_lead_time,0)), nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0))) lead_time,
2459: l_supply_level,
2460: sysdate,
2461: fnd_global.user_id,
2462: fnd_global.user_id,
2463: sysdate
2464: from mtl_parameters mp,
2465: mtl_system_items_b msib,
2466: mtl_item_sub_inventories misi,

Line 2495: fnd_global.user_id,

2491: decode(nvl(msib.preprocessing_lead_time,0) + nvl(msib.full_lead_time,0) + nvl(msib.postprocessing_lead_time,0),0, nvl(msi.preprocessing_lead_time,0) + nvl(msi.processing_lead_time,0) + nvl(msi.postprocessing_lead_time,0),
2492: nvl(msib.preprocessing_lead_time,0) + nvl(msib.full_lead_time,0) + nvl(msib.postprocessing_lead_time,0)), nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0))) ,
2493: l_supply_level,
2494: sysdate,
2495: fnd_global.user_id,
2496: fnd_global.user_id,
2497: sysdate;
2498:
2499: if sql%notfound then

Line 2496: fnd_global.user_id,

2492: nvl(msib.preprocessing_lead_time,0) + nvl(msib.full_lead_time,0) + nvl(msib.postprocessing_lead_time,0)), nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0))) ,
2493: l_supply_level,
2494: sysdate,
2495: fnd_global.user_id,
2496: fnd_global.user_id,
2497: sysdate;
2498:
2499: if sql%notfound then
2500: exit;

Line 2628: fnd_global.user_id,

2624: transaction_type_id,
2625: sum(mmt.primary_quantity) * -1 primary_quantity,
2626: 1, -- History data type
2627: 3, -- Period type
2628: fnd_global.user_id,
2629: sysdate,
2630: fnd_global.user_id,
2631: sysdate
2632: from mtl_material_transactions mmt

Line 2630: fnd_global.user_id,

2626: 1, -- History data type
2627: 3, -- Period type
2628: fnd_global.user_id,
2629: sysdate,
2630: fnd_global.user_id,
2631: sysdate
2632: from mtl_material_transactions mmt
2633: where mmt.creation_date >
2634: decode(G_LAST_RUN_DATE,fnd_api.g_miss_date,G_LAST_RUN_DATE,

Line 2645: fnd_global.user_id,

2641: trunc(transaction_date),
2642: transaction_type_id,
2643: 1, -- History data type
2644: 3, -- Period type
2645: fnd_global.user_id,
2646: sysdate,
2647: fnd_global.user_id,
2648: sysdate;
2649:

Line 2647: fnd_global.user_id,

2643: 1, -- History data type
2644: 3, -- Period type
2645: fnd_global.user_id,
2646: sysdate,
2647: fnd_global.user_id,
2648: sysdate;
2649:
2650: -- Rollup Usage History through Supply Chain
2651: loop

Line 2675: fnd_global.user_id,

2671: transaction_type_id,
2672: sum(cuh.quantity),
2673: 1,--heh decode(csc.source_type,2,3,1), -- History data type
2674: 3, -- Period type
2675: fnd_global.user_id,
2676: sysdate,
2677: fnd_global.user_id,
2678: sysdate
2679: from csp_supply_chain csc,

Line 2677: fnd_global.user_id,

2673: 1,--heh decode(csc.source_type,2,3,1), -- History data type
2674: 3, -- Period type
2675: fnd_global.user_id,
2676: sysdate,
2677: fnd_global.user_id,
2678: sysdate
2679: from csp_supply_chain csc,
2680: csp_usage_histories cuh
2681: where cuh.history_data_type = 1

Line 2695: fnd_global.user_id,

2691: trunc(cuh.period_start_date),
2692: transaction_type_id,
2693: 1,--heh decode(csc.source_type,2,3,1), -- History data type
2694: 3, -- Period type
2695: fnd_global.user_id,
2696: sysdate,
2697: fnd_global.user_id,
2698: sysdate;
2699: if sql%notfound then

Line 2697: fnd_global.user_id,

2693: 1,--heh decode(csc.source_type,2,3,1), -- History data type
2694: 3, -- Period type
2695: fnd_global.user_id,
2696: sysdate,
2697: fnd_global.user_id,
2698: sysdate;
2699: if sql%notfound then
2700: exit;
2701: end if;

Line 2910: FND_GLOBAL.user_id,

2906: VALUES (sq.INVENTORY_ITEM_ID,
2907: sq.ORGANIZATION_ID,
2908: sq.SECONDARY_INVENTORY,
2909: sysdate,
2910: FND_GLOBAL.user_id,
2911: sysdate,
2912: FND_GLOBAL.user_id,
2913: FND_GLOBAL.conc_login_id,
2914: sq.RECOMMENDED_MIN_QUANTITY,

Line 2912: FND_GLOBAL.user_id,

2908: sq.SECONDARY_INVENTORY,
2909: sysdate,
2910: FND_GLOBAL.user_id,
2911: sysdate,
2912: FND_GLOBAL.user_id,
2913: FND_GLOBAL.conc_login_id,
2914: sq.RECOMMENDED_MIN_QUANTITY,
2915: sq.RECOMMENDED_MAX_QUANTITY,2);
2916: COMMIT;

Line 2913: FND_GLOBAL.conc_login_id,

2909: sysdate,
2910: FND_GLOBAL.user_id,
2911: sysdate,
2912: FND_GLOBAL.user_id,
2913: FND_GLOBAL.conc_login_id,
2914: sq.RECOMMENDED_MIN_QUANTITY,
2915: sq.RECOMMENDED_MAX_QUANTITY,2);
2916: COMMIT;
2917: */

Line 2943: FND_GLOBAL.user_id,

2939: VALUES (usg_hdr_rec.INVENTORY_ITEM_ID,
2940: usg_hdr_rec.ORGANIZATION_ID,
2941: usg_hdr_rec.SECONDARY_INVENTORY,
2942: sysdate,
2943: FND_GLOBAL.user_id,
2944: sysdate,
2945: FND_GLOBAL.user_id,
2946: FND_GLOBAL.conc_login_id,
2947: usg_hdr_rec.RECOMMENDED_MIN_QUANTITY,

Line 2945: FND_GLOBAL.user_id,

2941: usg_hdr_rec.SECONDARY_INVENTORY,
2942: sysdate,
2943: FND_GLOBAL.user_id,
2944: sysdate,
2945: FND_GLOBAL.user_id,
2946: FND_GLOBAL.conc_login_id,
2947: usg_hdr_rec.RECOMMENDED_MIN_QUANTITY,
2948: usg_hdr_rec.RECOMMENDED_MAX_QUANTITY,2);
2949: END IF;

Line 2946: FND_GLOBAL.conc_login_id,

2942: sysdate,
2943: FND_GLOBAL.user_id,
2944: sysdate,
2945: FND_GLOBAL.user_id,
2946: FND_GLOBAL.conc_login_id,
2947: usg_hdr_rec.RECOMMENDED_MIN_QUANTITY,
2948: usg_hdr_rec.RECOMMENDED_MAX_QUANTITY,2);
2949: END IF;
2950: