DBA Data[Home] [Help]

APPS.PO_VENDORS_SV dependencies on ORG_FREIGHT

Line 471: FROM org_freight

467: /* Check if the given Freight Code is active */
468:
469: SELECT freight_code
470: INTO X_res_ship_via
471: FROM org_freight
472: WHERE organization_id = X_org_id
473: AND freight_code = X_temp_ship_via
474: AND nvl(disable_date, sysdate + 1) > sysdate;
475:

Line 677: from org_freight

673: /* Get the displayed value for a given Ship Via Lookup Code */
674:
675: select description
676: into X_ship_via_dsp
677: from org_freight
678: where organization_id = X_org_id
679: and freight_code = X_res_ship_via
680: and nvl(disable_date, sysdate + 1) > sysdate;
681: