DBA Data[Home] [Help]

APPS.AR_INVOICE_UTILS dependencies on ORG_FREIGHT

Line 161: FROM org_freight orf

157: FROM ar_trx_header_gt gt
158: WHERE gt.ship_via IS NOT NULL
159: AND NOT EXISTS
160: (SELECT 'X'
161: FROM org_freight orf
162: WHERE orf.freight_code = gt.ship_via
163: AND orf.organization_id = pg_so_org_id /*Bug4709987*/
164: AND gt.trx_date <= nvl(trunc(orf.disable_date), gt.trx_date));
165:

Line 4846: org_freight fr

4842: WHERE gt.line_type = 'FREIGHT'
4843: AND gt.ship_via IS NOT NULL
4844: AND NOT EXISTS (
4845: SELECT 'X' FROM
4846: org_freight fr
4847: WHERE fr.organization_id = gt.org_id
4848: and gt.trx_date <= nvl(trunc(disable_date), gt.trx_date)
4849: and freight_code = gt.ship_via);
4850: