APPS.QLTTRAWB dependencies on MTL_PARAMETERS

Line 1561: ' MTL_PARAMETERS MP ' ||

1557: 'MP.STOCK_LOCATOR_CONTROL_CODE, ' ||
1558: 'MP.NEGATIVE_INV_RECEIPT_CODE, ' ||
1559: 'QRI.' || COMP_TEXT || 'ITEM_ID ' ||
1560: 'FROM QA_RESULTS_INTERFACE QRI, ' ||
1561: ' MTL_PARAMETERS MP ' ||
1562: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1563: ' AND QRI.PROCESS_STATUS = 2 ' ||
1564: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
1565: ' AND NOT EXISTS

Line 1896: ' MTL_PARAMETERS MP ' ||

1892: 'MP.STOCK_LOCATOR_CONTROL_CODE, ' ||
1893: 'MP.NEGATIVE_INV_RECEIPT_CODE, ' ||
1894: 'QRI.ITEM_ID ' ||
1895: 'FROM QA_RESULTS_INTERFACE QRI, ' ||
1896: ' MTL_PARAMETERS MP ' ||
1897: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1898: ' AND QRI.PROCESS_STATUS = 2 ' ||
1899: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
1900: ' AND NOT EXISTS

Line 5258: -- replaced ORG_ORGANIZATION_DEFINITIONS with MTL_PARAMETERS

5254:
5255:
5256: -- group validation for organization_code
5257: -- Bug 4958776. SQL Repository Fix SQL ID: 15009159
5258: -- replaced ORG_ORGANIZATION_DEFINITIONS with MTL_PARAMETERS
5259: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,
5260: ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
5261: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
5262: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,

Line 5280: FROM MTL_PARAMETERS OOD

5276: QRI.TRANSACTION_INTERFACE_ID
5277: AND QIE.ERROR_COLUMN IN ('ORGANIZATION_CODE', NULL))
5278: AND NOT EXISTS
5279: (SELECT 'X'
5280: FROM MTL_PARAMETERS OOD
5281: WHERE QRI.ORGANIZATION_CODE = OOD.ORGANIZATION_CODE);
5282: -- AND NVL(OOD.DISABLE_DATE, SYSDATE) >= SYSDATE);
5283:
5284: If (sql%rowcount >0) THEN

Line 5290: -- replaced ORG_ORGANIZATION_DEFINITIONS with MTL_PARAMETERS

5286: END IF;
5287:
5288: -- group derivation for organization_id
5289: -- Bug 4958776. SQL Repository Fix SQL ID: 15009164
5290: -- replaced ORG_ORGANIZATION_DEFINITIONS with MTL_PARAMETERS
5291: UPDATE QA_RESULTS_INTERFACE QRI
5292: SET LAST_UPDATE_DATE = SYSDATE,
5293: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
5294: REQUEST_ID = X_REQUEST_ID,

Line 5300: FROM MTL_PARAMETERS OOD

5296: PROGRAM_ID = X_PROGRAM_ID,
5297: PROGRAM_UPDATE_DATE = SYSDATE,
5298: ORGANIZATION_ID =
5299: (SELECT MIN(OOD.ORGANIZATION_ID)
5300: FROM MTL_PARAMETERS OOD
5301: WHERE OOD.ORGANIZATION_CODE = QRI.ORGANIZATION_CODE)
5302: WHERE QRI.GROUP_ID = X_GROUP_ID
5303: AND QRI.PROCESS_STATUS = 2
5304: AND NOT EXISTS

Line 6360: 'mtl_system_items_b_kfv msikfv, mtl_parameters mp',

6356: X_LAST_UPDATE_LOGIN,
6357: X_REQUEST_ID,
6358: X_PROGRAM_APPLICATION_ID,
6359: X_PROGRAM_ID,
6360: 'mtl_system_items_b_kfv msikfv, mtl_parameters mp',
6361: 'qri.asset_group = msikfv.concatenated_segments' ||
6362: ' and msikfv.organization_id = mp.organization_id' ||
6363: ' and msikfv.eam_item_type in (1,3) ' ||
6364: ' and mp.maint_organization_id = qri.organization_id',

Line 8248: FROM MTL_PARAMETERS OOD

8244: PROGRAM_ID = X_PROGRAM_ID,
8245: PROGRAM_UPDATE_DATE = SYSDATE,
8246: ORGANIZATION_ID =
8247: (SELECT MIN(OOD.ORGANIZATION_ID)
8248: FROM MTL_PARAMETERS OOD
8249: WHERE OOD.ORGANIZATION_CODE = QRI.ORGANIZATION_CODE)
8250: WHERE GROUP_ID = X_GROUP_ID
8251: AND PROCESS_STATUS = 2;
8252: