1400: AND NOT EXISTS (
1401: SELECT
1402: null
1403: FROM
1404: MTL_SYSTEM_ITEMS MSI
1405: WHERE MSI.ORGANIZATION_ID = P1.TRANSACTION_ORGANIZATION_ID
1406: AND MSI.INVENTORY_ITEM_ID = P1.INVENTORY_ITEM_ID );
1407: /*SRW.MESSAGE(201
1408: ,'match_no_item() >> ' || TO_CHAR(SYSDATE
2904: CST_AE_HEADERS CAH,
2905: CST_AE_LINES CAL,
2906: MTL_MATERIAL_TRANSACTIONS MMT,
2907: MTL_TRANSACTION_TYPES MTT,
2908: MTL_SYSTEM_ITEMS MSI,
2909: CST_PAC_ACCRUAL_ACCOUNTS_TEMP CAA
2910: WHERE CAA.REQUEST_ID = P_CONC_REQUEST_ID
2911: AND CAL.CODE_COMBINATION_ID = CAA.ACCRUAL_ACCOUNT_ID
2912: AND CAL.AE_HEADER_ID = CAH.AE_HEADER_ID