APPS.AR_UNPOSTED_ITEM_UPG dependencies on PSA_TRX_TYPES_ALL

Line 79: FROM psa_trx_types_all psa,

75: AND app.rowid >= p_start_rowid
76: AND app.rowid <= p_end_rowid
77: AND ars.accounting_method = 'CASH'
78: AND NOT EXISTS (SELECT '1'
79: FROM psa_trx_types_all psa,
80: ra_customer_trx_all inv
81: WHERE inv.customer_trx_id = app.applied_customer_trx_id
82: AND inv.cust_trx_type_id = psa.psa_trx_type_id)
83: ORDER BY app.org_id;

Line 354: FROM psa_trx_types_all psa,

350: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')
351: AND ctlgd.account_class IN ('REV','SUSPENSE','UNBILL','UNEARN','FREIGHT','TAX')
352: AND ctlgd.account_set_flag = 'N'
353: AND NOT EXISTS (SELECT '1'
354: FROM psa_trx_types_all psa,
355: ra_customer_trx_all inv
356: WHERE inv.customer_trx_id = app.applied_customer_trx_id
357: AND inv.cust_trx_type_id = psa.psa_trx_type_id);
358:

Line 866: FROM psa_trx_types_all psa,

862: AND ars.accounting_method = 'CASH'
863: AND app.customer_trx_id IS NOT NULL
864: AND app.cash_receipt_id IS NULL
865: AND NOT EXISTS (SELECT '1'
866: FROM psa_trx_types_all psa,
867: ra_customer_trx_all inv
868: WHERE inv.customer_trx_id = app.customer_trx_id
869: AND inv.cust_trx_type_id = psa.psa_trx_type_id)
870: ORDER BY app.org_id;

Line 1142: FROM psa_trx_types_all psa,

1138: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')
1139: AND ctlgd.account_class IN ('REV','SUSPENSE','UNBILL','UNEARN','FREIGHT','TAX')
1140: AND ctlgd.account_set_flag = 'N'
1141: AND NOT EXISTS (SELECT '1'
1142: FROM psa_trx_types_all psa,
1143: ra_customer_trx_all inv
1144: WHERE inv.customer_trx_id = app.customer_trx_id
1145: AND inv.cust_trx_type_id = psa.psa_trx_type_id);
1146: