APPS.PSA_MFAR_VAL_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 51: from psa_trx_types_ALL a, ra_cust_trx_types_all b

47: return;
48: end if;
49:
50: SELECT 'X' into l_trx_type_check
51: from psa_trx_types_ALL a, ra_cust_trx_types_all b
52: where a.psa_trx_type_id = X_TRANSACTION_TYPE_ID
53: AND a.psa_trx_type_id = b.cust_trx_type_id ;
54:
55: -- EXCEPTION

Line 665: ra_cust_trx_types_all B,

661: DECODE(B.TYPE ,'GUAR','Commitments Can not be Multi Fund Transactions Type',
662: 'CB' ,'Multi Fund TRansactions Can not be Charged Back' ,
663: 'CM' , 'On-Account Credit Can not use Multi Fund Transaction types')
664: FROM ra_interface_lines_gt L,
665: ra_cust_trx_types_all B,
666: psa_trx_types_all C
667: WHERE L.REQUEST_ID = l_request_id
668: AND L.cust_trx_type_id = B.cust_trx_type_id
669: AND B.TYPE in ('GUAR', 'CB', 'CM')

Line 689: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,

685: WHERE L.REQUEST_ID = l_request_id
686: AND ( L.INVOICING_RULE_ID IS NOT NULL
687: OR L.INVOICING_RULE_NAME IS NOT NULL )
688: AND exists
689: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,
690: PSA_TRX_TYPES_ALL C
691: WHERE B.CUST_TRX_TYPE_ID = C.PSA_TRX_TYPE_ID
692: AND B.CUST_TRX_TYPE_ID = L.CUST_TRX_TYPE_ID ) ;
693:

Line 708: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,

704: 'Transaction Currency Should be Equal to the GL Functional Currency'
705: FROM RA_INTERFACE_LINES_GT L
706: WHERE L.REQUEST_ID = l_request_id
707: AND exists
708: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,
709: PSA_TRX_TYPES_ALL C
710: WHERE B.CUST_TRX_TYPE_ID = C.PSA_TRX_TYPE_ID
711: AND B.CUST_TRX_TYPE_ID = L.CUST_TRX_TYPE_ID )
712: AND not exists

Line 735: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,

731: 'Can not Mark Multi Fund Transactions for Automatic Receipts '
732: FROM RA_INTERFACE_LINES_GT L
733: WHERE L.REQUEST_ID = l_request_id
734: AND exists
735: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,
736: PSA_TRX_TYPES_ALL C
737: WHERE B.CUST_TRX_TYPE_ID = C.PSA_TRX_TYPE_ID
738: AND B.CUST_TRX_TYPE_ID = L.CUST_TRX_TYPE_ID )
739: AND exists

Line 764: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,

760: 'Can not Assign Commitments to Multi Fund Transactions'
761: FROM RA_INTERFACE_LINES_GT L
762: WHERE L.REQUEST_ID = l_request_id
763: AND exists
764: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,
765: PSA_TRX_TYPES_ALL C
766: WHERE B.CUST_TRX_TYPE_ID = C.PSA_TRX_TYPE_ID
767: AND B.TYPE = 'INV'
768: AND L.REFERENCE_LINE_ID is not null

Line 778: -- Bug 2571462 : Added Join between ra_cust_trx_types_all and psa_trx_types_all

774: | Otherwise this transaction will be qualified as MFAR |
775: | transaction |
776: +-------------------------------------------------------------------------*/
777:
778: -- Bug 2571462 : Added Join between ra_cust_trx_types_all and psa_trx_types_all
779: -- This will supersede bug 2503680
780:
781: INSERT INTO RA_INTERFACE_ERRORS
782: (INTERFACE_LINE_ID,

Line 789: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,

785: 'Credit Memo Profile Option must use Invoice Accounting for Multi Fund Transactions'
786: FROM RA_INTERFACE_LINES_GT L
787: WHERE L.REQUEST_ID = l_request_id
788: AND exists
789: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,
790: PSA_TRX_TYPES_ALL C
791: WHERE fnd_profile.value('AR_USE_INV_ACCT_FOR_CM_FLAG') <> 'Y'
792: AND B.TYPE = 'CM'
793: AND L.REFERENCE_LINE_ID is not null