DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on RA_CUST_TRX_TYPES

Line 3958: (SELECT 1 FROM ra_cust_trx_types ractt

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