DBA Data[Home] [Help]

APPS.INVPUTLI dependencies on MTL_PARAMETERS

Line 2141: FROM mtl_parameters

2137: WHERE I.rowid = p_rowid;
2138:
2139: SELECT starting_revision
2140: INTO l_revision
2141: FROM mtl_parameters
2142: WHERE organization_id = l_org_id;
2143:
2144: IF (temp_desc IS NULL) THEN
2145: IF (l_item_catalog_group_id IS NOT NULL) THEN

Line 2597: FROM MTL_PARAMETERS M

2593: I.LOCATION_CONTROL_CODE = DECODE(I.LOCATION_CONTROL_CODE, NULL, 1, I.LOCATION_CONTROL_CODE),
2594: I.LOT_CONTROL_CODE = DECODE(I.LOT_CONTROL_CODE, NULL, 1, I.LOT_CONTROL_CODE),
2595: I.MRP_SAFETY_STOCK_CODE = DECODE(I.MRP_SAFETY_STOCK_CODE,NULL,1,I.MRP_SAFETY_STOCK_CODE),
2596: I.revision = ( SELECT DECODE(I.revision, NULL,M.STARTING_REVISION, I.revision)
2597: FROM MTL_PARAMETERS M
2598: WHERE M.organization_id = org_id ),
2599: I.LAST_UPDATE_DATE = NVL(I.LAST_UPDATE_DATE,l_sysdate),
2600: I.CREATION_DATE = NVL(I.CREATION_DATE,l_sysdate),
2601: I.SHIP_MODEL_COMPLETE_FLAG = DECODE(I.SHIP_MODEL_COMPLETE_FLAG, NULL, 'N', I.SHIP_MODEL_COMPLETE_FLAG ),