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 1543: fnd_global.user_id, sysdate,

1539: period_start_date,
1540: quantity,
1541: history_data_type)
1542: VALUES ( csp_usage_histories_s1.nextval,
1543: fnd_global.user_id, sysdate,
1544: fnd_global.user_id,sysdate,
1545: l_Prev_Rec.Inventory_Item_id,
1546: l_Prev_Rec.Organization_id,
1547: l_Prev_Rec.Subinventory_code,

Line 1544: fnd_global.user_id,sysdate,

1540: quantity,
1541: history_data_type)
1542: VALUES ( csp_usage_histories_s1.nextval,
1543: fnd_global.user_id, sysdate,
1544: fnd_global.user_id,sysdate,
1545: l_Prev_Rec.Inventory_Item_id,
1546: l_Prev_Rec.Organization_id,
1547: l_Prev_Rec.Subinventory_code,
1548: 3,

Line 1602: fnd_global.user_id,

1598: 'N',
1599: NULL,
1600: NULL,
1601: SYSDATE,
1602: fnd_global.user_id,
1603: SYSDATE,
1604: fnd_global.user_id,
1605: fnd_global.conc_login_id);
1606: End If;

Line 1604: fnd_global.user_id,

1600: NULL,
1601: SYSDATE,
1602: fnd_global.user_id,
1603: SYSDATE,
1604: fnd_global.user_id,
1605: fnd_global.conc_login_id);
1606: End If;
1607: l_count := 0;
1608: l_Usage_Quantity := 0;

Line 1605: fnd_global.conc_login_id);

1601: SYSDATE,
1602: fnd_global.user_id,
1603: SYSDATE,
1604: fnd_global.user_id,
1605: fnd_global.conc_login_id);
1606: End If;
1607: l_count := 0;
1608: l_Usage_Quantity := 0;
1609: l_Forecast_Quantity := 0;

Line 1755: fnd_global.user_id,

1751: nvl(manual_failure_rate,calculated_failure_rate),
1752: 'O',
1753: 'N',
1754: sysdate,
1755: fnd_global.user_id,
1756: sysdate,
1757: fnd_global.user_id,
1758: fnd_global.conc_login_id
1759: from csp_product_populations_fr_v cppf,

Line 1757: fnd_global.user_id,

1753: 'N',
1754: sysdate,
1755: fnd_global.user_id,
1756: sysdate,
1757: fnd_global.user_id,
1758: fnd_global.conc_login_id
1759: from csp_product_populations_fr_v cppf,
1760: csp_supersede_items csi
1761: where cppf.level_id like p_level_id || '%'

Line 1758: fnd_global.conc_login_id

1754: sysdate,
1755: fnd_global.user_id,
1756: sysdate,
1757: fnd_global.user_id,
1758: fnd_global.conc_login_id
1759: from csp_product_populations_fr_v cppf,
1760: csp_supersede_items csi
1761: where cppf.level_id like p_level_id || '%'
1762: and cppf.node_type in ('ORGANIZATION_WH','SUBINVENTORY')

Line 1888: fnd_global.user_id,

1884: cnpp.calculated_failure_rate),
1885: 'O',
1886: 'N',
1887: sysdate,
1888: fnd_global.user_id,
1889: sysdate,
1890: fnd_global.user_id,
1891: fnd_global.conc_login_id
1892: from csp_new_product_planning_v cnpp,

Line 1890: fnd_global.user_id,

1886: 'N',
1887: sysdate,
1888: fnd_global.user_id,
1889: sysdate,
1890: fnd_global.user_id,
1891: fnd_global.conc_login_id
1892: from csp_new_product_planning_v cnpp,
1893: csp_supersede_items csi
1894: where cnpp.level_id like p_level_id || '%'

Line 1891: fnd_global.conc_login_id

1887: sysdate,
1888: fnd_global.user_id,
1889: sysdate,
1890: fnd_global.user_id,
1891: fnd_global.conc_login_id
1892: from csp_new_product_planning_v cnpp,
1893: csp_supersede_items csi
1894: where cnpp.level_id like p_level_id || '%'
1895: and csi.inventory_item_id(+) = cnpp.inventory_item_id

Line 2017: fnd_global.user_id,

2013: curos.awu,
2014: 'O',
2015: 'N',
2016: sysdate,
2017: fnd_global.user_id,
2018: sysdate,
2019: fnd_global.user_id,
2020: fnd_global.conc_login_id
2021: from csp_usage_reg_org_subinv_v curos,

Line 2019: fnd_global.user_id,

2015: 'N',
2016: sysdate,
2017: fnd_global.user_id,
2018: sysdate,
2019: fnd_global.user_id,
2020: fnd_global.conc_login_id
2021: from csp_usage_reg_org_subinv_v curos,
2022: csp_supersede_items csi
2023: where curos.level_id like p_level_id || '%'

Line 2020: fnd_global.conc_login_id

2016: sysdate,
2017: fnd_global.user_id,
2018: sysdate,
2019: fnd_global.user_id,
2020: fnd_global.conc_login_id
2021: from csp_usage_reg_org_subinv_v curos,
2022: csp_supersede_items csi
2023: where curos.level_id like p_level_id || '%'
2024: and csi.inventory_item_id (+) = curos.inventory_item_id

Line 2185: fnd_global.user_id,

2181: cri.inventory_item_id,
2182: NULL,
2183: 1, -- supply_level
2184: sysdate,
2185: fnd_global.user_id,
2186: fnd_global.user_id,
2187: sysdate
2188: from csp_region_items_v cri,
2189: mtl_related_items mri,

Line 2186: fnd_global.user_id,

2182: NULL,
2183: 1, -- supply_level
2184: sysdate,
2185: fnd_global.user_id,
2186: fnd_global.user_id,
2187: sysdate
2188: from csp_region_items_v cri,
2189: mtl_related_items mri,
2190: mtl_parameters mp,

Line 2237: fnd_global.user_id,

2233: csc.inventory_item_id,
2234: NULL,
2235: l_supply_level,
2236: sysdate,
2237: fnd_global.user_id,
2238: fnd_global.user_id,
2239: sysdate
2240: from mtl_parameters mp,
2241: mtl_system_items_b msib,

Line 2238: fnd_global.user_id,

2234: NULL,
2235: l_supply_level,
2236: sysdate,
2237: fnd_global.user_id,
2238: fnd_global.user_id,
2239: sysdate
2240: from mtl_parameters mp,
2241: mtl_system_items_b msib,
2242: mtl_item_sub_inventories misi,

Line 2415: fnd_global.user_id,

2411: 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)),
2412: nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0))) lead_time,
2413: 1, -- supply_level
2414: sysdate,
2415: fnd_global.user_id,
2416: fnd_global.user_id,
2417: sysdate
2418: from mtl_parameters mp,
2419: mtl_system_items_b msib,

Line 2416: fnd_global.user_id,

2412: nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0))) lead_time,
2413: 1, -- supply_level
2414: sysdate,
2415: fnd_global.user_id,
2416: fnd_global.user_id,
2417: sysdate
2418: from mtl_parameters mp,
2419: mtl_system_items_b msib,
2420: mtl_item_sub_inventories misi,

Line 2450: fnd_global.user_id,

2446: 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)),
2447: nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0))) ,
2448: 1,
2449: sysdate,
2450: fnd_global.user_id,
2451: fnd_global.user_id,
2452: sysdate;
2453:
2454: loop

Line 2451: fnd_global.user_id,

2447: nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0))) ,
2448: 1,
2449: sysdate,
2450: fnd_global.user_id,
2451: fnd_global.user_id,
2452: sysdate;
2453:
2454: loop
2455: l_supply_level := l_supply_level + 1;

Line 2481: fnd_global.user_id,

2477: 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),
2478: 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,
2479: l_supply_level,
2480: sysdate,
2481: fnd_global.user_id,
2482: fnd_global.user_id,
2483: sysdate
2484: from mtl_parameters mp,
2485: mtl_system_items_b msib,

Line 2482: fnd_global.user_id,

2478: 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,
2479: l_supply_level,
2480: sysdate,
2481: fnd_global.user_id,
2482: fnd_global.user_id,
2483: sysdate
2484: from mtl_parameters mp,
2485: mtl_system_items_b msib,
2486: mtl_item_sub_inventories misi,

Line 2515: fnd_global.user_id,

2511: 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),
2512: 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))) ,
2513: l_supply_level,
2514: sysdate,
2515: fnd_global.user_id,
2516: fnd_global.user_id,
2517: sysdate;
2518:
2519: if sql%notfound then

Line 2516: fnd_global.user_id,

2512: 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))) ,
2513: l_supply_level,
2514: sysdate,
2515: fnd_global.user_id,
2516: fnd_global.user_id,
2517: sysdate;
2518:
2519: if sql%notfound then
2520: exit;

Line 2648: fnd_global.user_id,

2644: transaction_type_id,
2645: sum(mmt.primary_quantity) * -1 primary_quantity,
2646: 1, -- History data type
2647: 3, -- Period type
2648: fnd_global.user_id,
2649: sysdate,
2650: fnd_global.user_id,
2651: sysdate
2652: from mtl_material_transactions mmt

Line 2650: fnd_global.user_id,

2646: 1, -- History data type
2647: 3, -- Period type
2648: fnd_global.user_id,
2649: sysdate,
2650: fnd_global.user_id,
2651: sysdate
2652: from mtl_material_transactions mmt
2653: where mmt.creation_date >
2654: decode(G_LAST_RUN_DATE,fnd_api.g_miss_date,G_LAST_RUN_DATE,

Line 2665: fnd_global.user_id,

2661: trunc(transaction_date),
2662: transaction_type_id,
2663: 1, -- History data type
2664: 3, -- Period type
2665: fnd_global.user_id,
2666: sysdate,
2667: fnd_global.user_id,
2668: sysdate;
2669:

Line 2667: fnd_global.user_id,

2663: 1, -- History data type
2664: 3, -- Period type
2665: fnd_global.user_id,
2666: sysdate,
2667: fnd_global.user_id,
2668: sysdate;
2669:
2670: -- Rollup Usage History through Supply Chain
2671: loop

Line 2695: fnd_global.user_id,

2691: transaction_type_id,
2692: sum(cuh.quantity),
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: from csp_supply_chain csc,

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: from csp_supply_chain csc,
2700: csp_usage_histories cuh
2701: where cuh.history_data_type = 1

Line 2715: fnd_global.user_id,

2711: trunc(cuh.period_start_date),
2712: transaction_type_id,
2713: 1,--heh decode(csc.source_type,2,3,1), -- History data type
2714: 3, -- Period type
2715: fnd_global.user_id,
2716: sysdate,
2717: fnd_global.user_id,
2718: sysdate;
2719: if sql%notfound then

Line 2717: fnd_global.user_id,

2713: 1,--heh decode(csc.source_type,2,3,1), -- History data type
2714: 3, -- Period type
2715: fnd_global.user_id,
2716: sysdate,
2717: fnd_global.user_id,
2718: sysdate;
2719: if sql%notfound then
2720: exit;
2721: end if;

Line 2930: FND_GLOBAL.user_id,

2926: VALUES (sq.INVENTORY_ITEM_ID,
2927: sq.ORGANIZATION_ID,
2928: sq.SECONDARY_INVENTORY,
2929: sysdate,
2930: FND_GLOBAL.user_id,
2931: sysdate,
2932: FND_GLOBAL.user_id,
2933: FND_GLOBAL.conc_login_id,
2934: sq.RECOMMENDED_MIN_QUANTITY,

Line 2932: FND_GLOBAL.user_id,

2928: sq.SECONDARY_INVENTORY,
2929: sysdate,
2930: FND_GLOBAL.user_id,
2931: sysdate,
2932: FND_GLOBAL.user_id,
2933: FND_GLOBAL.conc_login_id,
2934: sq.RECOMMENDED_MIN_QUANTITY,
2935: sq.RECOMMENDED_MAX_QUANTITY,2);
2936: COMMIT;

Line 2933: FND_GLOBAL.conc_login_id,

2929: sysdate,
2930: FND_GLOBAL.user_id,
2931: sysdate,
2932: FND_GLOBAL.user_id,
2933: FND_GLOBAL.conc_login_id,
2934: sq.RECOMMENDED_MIN_QUANTITY,
2935: sq.RECOMMENDED_MAX_QUANTITY,2);
2936: COMMIT;
2937: */

Line 2963: FND_GLOBAL.user_id,

2959: VALUES (usg_hdr_rec.INVENTORY_ITEM_ID,
2960: usg_hdr_rec.ORGANIZATION_ID,
2961: usg_hdr_rec.SECONDARY_INVENTORY,
2962: sysdate,
2963: FND_GLOBAL.user_id,
2964: sysdate,
2965: FND_GLOBAL.user_id,
2966: FND_GLOBAL.conc_login_id,
2967: usg_hdr_rec.RECOMMENDED_MIN_QUANTITY,

Line 2965: FND_GLOBAL.user_id,

2961: usg_hdr_rec.SECONDARY_INVENTORY,
2962: sysdate,
2963: FND_GLOBAL.user_id,
2964: sysdate,
2965: FND_GLOBAL.user_id,
2966: FND_GLOBAL.conc_login_id,
2967: usg_hdr_rec.RECOMMENDED_MIN_QUANTITY,
2968: usg_hdr_rec.RECOMMENDED_MAX_QUANTITY,2);
2969: END IF;

Line 2966: FND_GLOBAL.conc_login_id,

2962: sysdate,
2963: FND_GLOBAL.user_id,
2964: sysdate,
2965: FND_GLOBAL.user_id,
2966: FND_GLOBAL.conc_login_id,
2967: usg_hdr_rec.RECOMMENDED_MIN_QUANTITY,
2968: usg_hdr_rec.RECOMMENDED_MAX_QUANTITY,2);
2969: END IF;
2970: