APPS.INV_TURNS dependencies on FND_GLOBAL

Line 335: l_user_id := FND_GLOBAL.USER_ID;

331:
332: BEGIN
333: FND_MSG_PUB.initialize;
334:
335: l_user_id := FND_GLOBAL.USER_ID;
336:
337: SAVEPOINT CLOSED_TB;
338:
339: DELETE FROM MTL_BIS_INV_BY_PERIOD

Line 430: l_user_id := FND_GLOBAL.USER_ID;

426: i NUMBER;
427:
428: BEGIN
429: FND_MSG_PUB.initialize;
430: l_user_id := FND_GLOBAL.USER_ID;
431:
432: SAVEPOINT CLOSED_SC;
433:
434: DELETE FROM MTL_BIS_INV_BY_PERIOD

Line 653: l_user_id := FND_GLOBAL.USER_ID;

649: AND WPB.wip_entity_id = WE.wip_entity_id
650: GROUP BY WPB.organization_id, WPB.acct_period_id, WE.primary_item_id;
651: BEGIN
652:
653: l_user_id := FND_GLOBAL.USER_ID;
654: l_last_period_id := NULL;
655:
656: SELECT MAX(acct_period_id)
657: INTO l_last_period_id

Line 782: l_user_id := FND_GLOBAL.USER_ID;

778: AND TRUNC(transaction_date) between
779: trunc(l_period_start_date) AND trunc(l_period_close_date)
780: GROUP BY inventory_item_id; */
781: BEGIN
782: l_user_id := FND_GLOBAL.USER_ID;
783:
784: SELECT period_start_date,schedule_close_date
785: INTO l_period_start_date, l_period_close_date
786: FROM org_acct_periods

Line 1199: l_user_id := FND_GLOBAL.USER_ID;

1195: AND NVL(MMT2.OWNING_TP_TYPE,2) = 2
1196: GROUP BY MTA.inventory_item_id
1197: ) group by inventory_item_id;
1198: BEGIN
1199: l_user_id := FND_GLOBAL.USER_ID;
1200:
1201: FOR OPEN_PERS_REC IN OPEN_PERS LOOP
1202:
1203: l_organization_id := OPEN_PERS_REC.organization_id;

Line 1435: l_user_id := FND_GLOBAL.USER_ID;

1431:
1432: BEGIN
1433: FND_MSG_PUB.initialize;
1434:
1435: l_user_id := FND_GLOBAL.USER_ID;
1436:
1437: INSERT INTO MTL_BIS_INV_BY_PERIOD
1438: (organization_id, acct_period_id, inventory_item_id, onhand,
1439: wip, intransit, cogs, last_update_date, last_updated_by,