DBA Data[Home] [Help]

APPS.MTL_LOT_NUMBERS_PKG dependencies on MTL_LOT_GRADE_HISTORY

Line 767: INSERT INTO MTL_LOT_GRADE_HISTORY

763:
764: /*========================
765: Upgrade Grade History
766: ========================*/
767: INSERT INTO MTL_LOT_GRADE_HISTORY
768: (
769: GRADE_UPDATE_ID,
770: INVENTORY_ITEM_ID,
771: ORGANIZATION_ID,

Line 806: MTL_LOT_GRADE_HISTORY_S.NEXTVAL,

802: LAST_UPDATE_LOGIN
803: )
804: VALUES
805: (
806: MTL_LOT_GRADE_HISTORY_S.NEXTVAL,
807: X_INVENTORY_ITEM_ID,
808: l_orgid,--X_ORGANIZATION_ID, --Global Lot ER
809: X_LOT_NUMBER,
810: INV_MATERIAL_STATUS_PUB.g_update_method_manual,/* Jalaj Srivastava Bug 4998256 pass update_method as manual instead of null */

Line 886: INSERT INTO MTL_LOT_GRADE_HISTORY

882:
883: /*========================
884: Upgrade Grade History
885: ========================*/
886: INSERT INTO MTL_LOT_GRADE_HISTORY
887: (
888: GRADE_UPDATE_ID,
889: INVENTORY_ITEM_ID,
890: ORGANIZATION_ID,

Line 925: MTL_LOT_GRADE_HISTORY_S.NEXTVAL,

921: LAST_UPDATE_LOGIN
922: )
923: VALUES
924: (
925: MTL_LOT_GRADE_HISTORY_S.NEXTVAL,
926: X_INVENTORY_ITEM_ID,
927: X_ORGANIZATION_ID,
928: X_LOT_NUMBER,
929: INV_MATERIAL_STATUS_PUB.g_update_method_manual,/* Jalaj Srivastava Bug 4998256 pass update_method as manual instead of null */