DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on ORG_FREIGHT

Line 3490: FROM ORG_FREIGHT FR

3486: AND FREIGHT_CODE IS NOT NULL
3487: AND PROCESS_FLAG = 1
3488: AND NOT EXISTS (
3489: SELECT NULL
3490: FROM ORG_FREIGHT FR
3491: WHERE FR.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3492: AND FR.FREIGHT_CODE = MTI.FREIGHT_CODE
3493: AND NVL(FR.DISABLE_DATE, SYSDATE + 1) > SYSDATE);
3494:

Line 3514: FROM ORG_FREIGHT FR

3510: AND TRANSPORTATION_ACCOUNT IS NOT NULL
3511: AND PROCESS_FLAG = 1
3512: AND NOT EXISTS (
3513: SELECT NULL
3514: FROM ORG_FREIGHT FR
3515: WHERE FR.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3516: AND FR.FREIGHT_CODE = MTI.FREIGHT_CODE
3517: AND FR.DISTRIBUTION_Account = MTI.TRANSPORTATION_ACCOUNT
3518: AND NVL(FR.DISABLE_DATE, SYSDATE + 1) > SYSDATE);