DBA Data[Home] [Help]

APPS.INV_KANBAN_PVT dependencies on HR_LOCATIONS

Line 2139: Default_to_location_Id Default location for the org in HR_LOCATIONS

2135: Created_By Userid
2136: Created_date Sysdate
2137: Last_Updated_By Userid
2138: Last_Update_Date Sysdate
2139: Default_to_location_Id Default location for the org in HR_LOCATIONS
2140: that has a customer in po_assosiation_locations
2141: Deliver_to_requestor_ID Buyer id of item
2142: Destination_Organization_id Org_id
2143: Destination_Subinventory Subinventory

Line 3530: hr_locations loc,

3526: -- Bug Fix 5185446 : Added distinct
3527: select distinct org.location_id
3528: into l_deliver_location_id
3529: from hr_organization_units org,
3530: hr_locations loc,
3531: po_location_associations_all pla
3532: where org.organization_id =
3533: l_kanban_card_Rec_Tbl(1).Organization_id
3534: and org.location_id = loc.location_id

Line 3545: hr_locations loc

3541: l_sql_stmt_no := 40;
3542: select org.location_id
3543: into l_deliver_location_id
3544: from hr_organization_units org,
3545: hr_locations loc
3546: where org.organization_id =
3547: l_kanban_card_Rec_Tbl(1).Organization_id
3548: and org.location_id = loc.location_id;
3549: