DBA Data[Home] [Help]

APPS.INVPUTLI dependencies on MTL_PARAMETERS

Line 2066: FROM mtl_parameters

2062: WHERE I.rowid = p_rowid;
2063:
2064: SELECT starting_revision
2065: INTO l_revision
2066: FROM mtl_parameters
2067: WHERE organization_id = l_org_id;
2068:
2069: IF (temp_desc IS NULL) THEN
2070: IF (l_item_catalog_group_id IS NOT NULL) THEN

Line 2511: FROM MTL_PARAMETERS M

2507: I.LOCATION_CONTROL_CODE = DECODE(I.LOCATION_CONTROL_CODE, NULL, 1, I.LOCATION_CONTROL_CODE),
2508: I.LOT_CONTROL_CODE = DECODE(I.LOT_CONTROL_CODE, NULL, 1, I.LOT_CONTROL_CODE),
2509: I.MRP_SAFETY_STOCK_CODE = DECODE(I.MRP_SAFETY_STOCK_CODE,NULL,1,I.MRP_SAFETY_STOCK_CODE),
2510: I.revision = ( SELECT DECODE(I.revision, NULL,M.STARTING_REVISION, I.revision)
2511: FROM MTL_PARAMETERS M
2512: WHERE M.organization_id = org_id ),
2513: I.LAST_UPDATE_DATE = NVL(I.LAST_UPDATE_DATE,l_sysdate),
2514: I.CREATION_DATE = NVL(I.CREATION_DATE,l_sysdate),
2515: I.SHIP_MODEL_COMPLETE_FLAG = DECODE(I.SHIP_MODEL_COMPLETE_FLAG, NULL, 'N', I.SHIP_MODEL_COMPLETE_FLAG ),