DBA Data[Home] [Help]

APPS.INV_PROCESS_TEMP dependencies on ORG_FREIGHT

Line 1257: FROM ORG_FREIGHT FR

1253: AND PROCESS_FLAG = 'Y'
1254: AND TRANSACTION_STATUS = 3
1255: AND NOT EXISTS (
1256: SELECT NULL
1257: FROM ORG_FREIGHT FR
1258: WHERE FR.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
1259: AND FR.FREIGHT_CODE = MMTT.FREIGHT_CODE
1260: AND NVL(FR.DISABLE_DATE, SYSDATE + 1) > SYSDATE);
1261: if SQL%FOUND then l_status := 0; else l_status := 1; end if;

Line 1280: FROM ORG_FREIGHT FR

1276: AND PROCESS_FLAG = 'Y'
1277: AND TRANSACTION_STATUS = 3
1278: AND NOT EXISTS (
1279: SELECT NULL
1280: FROM ORG_FREIGHT FR
1281: WHERE FR.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
1282: AND FR.FREIGHT_CODE = MMTT.FREIGHT_CODE
1283: AND FR.DISTRIBUTION_ACCOUNT = MMTT.TRANSPORTATION_ACCOUNT
1284: AND NVL(FR.DISABLE_DATE, SYSDATE + 1) > SYSDATE);