APPS.QLTTRAWB dependencies on MTL_PARAMETERS

Line 1488: ' MTL_PARAMETERS MP ' ||

1484: 'MP.STOCK_LOCATOR_CONTROL_CODE, ' ||
1485: 'MP.NEGATIVE_INV_RECEIPT_CODE, ' ||
1486: 'QRI.' || COMP_TEXT || 'ITEM_ID ' ||
1487: 'FROM QA_RESULTS_INTERFACE QRI, ' ||
1488: ' MTL_PARAMETERS MP ' ||
1489: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1490: ' AND QRI.PROCESS_STATUS = 2 ' ||
1491: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
1492: ' AND NOT EXISTS

Line 1813: ' MTL_PARAMETERS MP ' ||

1809: 'MP.STOCK_LOCATOR_CONTROL_CODE, ' ||
1810: 'MP.NEGATIVE_INV_RECEIPT_CODE, ' ||
1811: 'QRI.ITEM_ID ' ||
1812: 'FROM QA_RESULTS_INTERFACE QRI, ' ||
1813: ' MTL_PARAMETERS MP ' ||
1814: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1815: ' AND QRI.PROCESS_STATUS = 2 ' ||
1816: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
1817: ' AND NOT EXISTS

Line 4919: -- replaced ORG_ORGANIZATION_DEFINITIONS with MTL_PARAMETERS

4915:
4916:
4917: -- group validation for organization_code
4918: -- Bug 4958776. SQL Repository Fix SQL ID: 15009159
4919: -- replaced ORG_ORGANIZATION_DEFINITIONS with MTL_PARAMETERS
4920: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,
4921: ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4922: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
4923: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,

Line 4941: FROM MTL_PARAMETERS OOD

4937: QRI.TRANSACTION_INTERFACE_ID
4938: AND QIE.ERROR_COLUMN IN ('ORGANIZATION_CODE', NULL))
4939: AND NOT EXISTS
4940: (SELECT 'X'
4941: FROM MTL_PARAMETERS OOD
4942: WHERE QRI.ORGANIZATION_CODE = OOD.ORGANIZATION_CODE);
4943: -- AND NVL(OOD.DISABLE_DATE, SYSDATE) >= SYSDATE);
4944:
4945: -- group derivation for organization_id

Line 4947: -- replaced ORG_ORGANIZATION_DEFINITIONS with MTL_PARAMETERS

4943: -- AND NVL(OOD.DISABLE_DATE, SYSDATE) >= SYSDATE);
4944:
4945: -- group derivation for organization_id
4946: -- Bug 4958776. SQL Repository Fix SQL ID: 15009164
4947: -- replaced ORG_ORGANIZATION_DEFINITIONS with MTL_PARAMETERS
4948: UPDATE QA_RESULTS_INTERFACE QRI
4949: SET LAST_UPDATE_DATE = SYSDATE,
4950: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
4951: REQUEST_ID = X_REQUEST_ID,

Line 4957: FROM MTL_PARAMETERS OOD

4953: PROGRAM_ID = X_PROGRAM_ID,
4954: PROGRAM_UPDATE_DATE = SYSDATE,
4955: ORGANIZATION_ID =
4956: (SELECT MIN(OOD.ORGANIZATION_ID)
4957: FROM MTL_PARAMETERS OOD
4958: WHERE OOD.ORGANIZATION_CODE = QRI.ORGANIZATION_CODE)
4959: WHERE QRI.GROUP_ID = X_GROUP_ID
4960: AND QRI.PROCESS_STATUS = 2
4961: AND NOT EXISTS

Line 5992: 'mtl_system_items_b_kfv msikfv, mtl_parameters mp',

5988: X_LAST_UPDATE_LOGIN,
5989: X_REQUEST_ID,
5990: X_PROGRAM_APPLICATION_ID,
5991: X_PROGRAM_ID,
5992: 'mtl_system_items_b_kfv msikfv, mtl_parameters mp',
5993: 'qri.asset_group = msikfv.concatenated_segments' ||
5994: ' and msikfv.organization_id = mp.organization_id' ||
5995: ' and msikfv.eam_item_type in (1,3) ' ||
5996: ' and mp.maint_organization_id = qri.organization_id',

Line 7732: FROM MTL_PARAMETERS OOD

7728: PROGRAM_ID = X_PROGRAM_ID,
7729: PROGRAM_UPDATE_DATE = SYSDATE,
7730: ORGANIZATION_ID =
7731: (SELECT MIN(OOD.ORGANIZATION_ID)
7732: FROM MTL_PARAMETERS OOD
7733: WHERE OOD.ORGANIZATION_CODE = QRI.ORGANIZATION_CODE)
7734: WHERE GROUP_ID = X_GROUP_ID
7735: AND PROCESS_STATUS = 2;
7736: