DBA Data[Home] [Help]

APPS.OKE_DELIVERABLE_UTILS_PKG dependencies on OKX_LOCATIONS_V

Line 142: okx_locations_v l

138: b.quantity,
139: b.uom_code
140: from oke_deliverables_b b,
141: hr_all_organization_units_vl v,
142: okx_locations_v l
143: --po_supplier_sites_val_v l
144: where source_code = x_source_code
145: and source_header_id = x_source_header_id
146: and source_deliverable_id = x_source_deliverable_id

Line 652: from okx_locations_v

648: or (ship_to_org_id = b_inv_org_id and action_type = 'REQ' ) );
649:
650: Cursor c_get_location(b_inv_org_id number) is
651: select id1
652: from okx_locations_v
653: where organization_id = b_inv_org_id;
654:
655: l_inv_changed Varchar2(1) :='Y';
656: l_location_count Number := 0;