DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on ORG_FREIGHT

Line 3303: FROM ORG_FREIGHT FR

3299: AND FREIGHT_CODE IS NOT NULL
3300: AND PROCESS_FLAG = 1
3301: AND NOT EXISTS (
3302: SELECT NULL
3303: FROM ORG_FREIGHT FR
3304: WHERE FR.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3305: AND FR.FREIGHT_CODE = MTI.FREIGHT_CODE
3306: AND NVL(FR.DISABLE_DATE, SYSDATE + 1) > SYSDATE);
3307:

Line 3327: FROM ORG_FREIGHT FR

3323: AND TRANSPORTATION_ACCOUNT IS NOT NULL
3324: AND PROCESS_FLAG = 1
3325: AND NOT EXISTS (
3326: SELECT NULL
3327: FROM ORG_FREIGHT FR
3328: WHERE FR.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3329: AND FR.FREIGHT_CODE = MTI.FREIGHT_CODE
3330: AND FR.DISTRIBUTION_Account = MTI.TRANSPORTATION_ACCOUNT
3331: AND NVL(FR.DISABLE_DATE, SYSDATE + 1) > SYSDATE);