DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on RA_CUST_TRX_TYPES

Line 3961: (SELECT 1 FROM ra_cust_trx_types ractt

3957: l_agreement_id NUMBER, l_commitment_id NUMBER, l_inventory_item_id NUMBER) IS
3958: SELECT 'VALID'
3959: FROM ra_customer_trx ratrx, ra_customer_trx_lines ratrl
3960: WHERE EXISTS
3961: (SELECT 1 FROM ra_cust_trx_types ractt
3962: WHERE ractt.type IN ('DEP', 'GUAR')
3963: AND ratrx.cust_trx_type_id = ractt.cust_trx_type_id
3964: AND ractt.org_id = l_org_id)
3965: AND ratrx.bill_to_customer_id = l_cust_account_id