DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_PKG dependencies on MTL_MATERIAL_STATUS_HISTORY_S

Line 279: Select MTL_MATERIAL_STATUS_HISTORY_S.nextval

275:
276: BEGIN
277: l_multiple_app := NVL(FND_PROFILE.VALUE('INV_ERES_MULTIPLE_SIGNATURE'),0);--ERES Deferred
278: --BEGIN SCHANDRU INVERES
279: Select MTL_MATERIAL_STATUS_HISTORY_S.nextval
280: Into l_status_update_id
281: From dual;
282: -- END SCHANDRU INVERES
283: l_status_rec := p_status_rec;

Line 342: --MTL_MATERIAL_STATUS_HISTORY_S.nextval

338: ,pending_status --ERES Deferred
339: )
340: VALUES (
341: -- BEGIN SCHANDRU INVERES
342: --MTL_MATERIAL_STATUS_HISTORY_S.nextval
343: l_status_update_id, -- Add this local variable so that it can be used to be stored in the temp table.
344: -- END SCHANDRU INVERES
345: l_status_rec.ORGANIZATION_ID
346: ,l_status_rec.INVENTORY_ITEM_ID

Line 413: Select MTL_MATERIAL_STATUS_HISTORY_S.nextval

409: p_status_rec.serial_number <> p_status_rec.to_serial_number then
410: l_to_serial_number := p_status_rec.to_serial_number;
411: FOR cc IN cur_serial_number LOOP
412: -- BEGIN SCHANDRU INVERES
413: Select MTL_MATERIAL_STATUS_HISTORY_S.nextval
414: Into l_status_update_id
415: From dual;
416:
417: -- END SCHANDRU INVERES

Line 464: --MTL_MATERIAL_STATUS_HISTORY_S.nextval

460: -- NSRIVAST, INVCONV , End
461: )
462: VALUES (
463: --BEGIN SCHANDRU INVERES
464: --MTL_MATERIAL_STATUS_HISTORY_S.nextval
465: l_status_update_id, -- Add this local variable so that it can be used to be stored in the temp table
466: -- END SCHANDRU INVERES
467: l_status_rec.ORGANIZATION_ID
468: ,l_status_rec.INVENTORY_ITEM_ID