DBA Data[Home] [Help]

APPS.POS_EXCELASN_PVT dependencies on ORG_FREIGHT

Line 2959: (select count(*) from org_freight oft

2955: select pht.line_number, pht.freight_carrier_code
2956: from pos_exasn_headers pht
2957: where pht.freight_carrier_code is not null
2958: and 0=
2959: (select count(*) from org_freight oft
2960: where nvl(oft.disable_date, sysdate) >= sysdate
2961: and oft.freight_code = pht.freight_carrier_code
2962: and organization_id = pht.ship_to_org_id
2963: );