DBA Data[Home] [Help]

APPS.RCV_RMA_TRANSACTIONS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 839: HR_ALL_ORGANIZATION_UNITS org --Bug 5217526. Earlier used org_organization_definitions

835: IF (x_cascaded_table(n).ship_to_location_id IS NOT NULL) THEN
836: SELECT MAX(org.organization_id)
837: INTO x_cascaded_table(n).to_organization_code
838: FROM hr_locations hl,
839: HR_ALL_ORGANIZATION_UNITS org --Bug 5217526. Earlier used org_organization_definitions
840: WHERE x_cascaded_table(n).ship_to_location_id = hl.location_id
841: AND hl.inventory_organization_id = org.organization_id;
842:
843: IF (g_asn_debug = 'Y') THEN

Line 850: HR_ALL_ORGANIZATION_UNITS org --Bug 5217526. Earlier used org_organization_definitions

846: ELSIF(x_cascaded_table(n).ship_to_location_code IS NOT NULL) THEN
847: SELECT MAX(org.organization_id)
848: INTO x_cascaded_table(n).to_organization_code
849: FROM hr_locations hl,
850: HR_ALL_ORGANIZATION_UNITS org --Bug 5217526. Earlier used org_organization_definitions
851: WHERE x_cascaded_table(n).ship_to_location_code = hl.location_code
852: AND hl.inventory_organization_id = org.organization_id;
853:
854: IF (g_asn_debug = 'Y') THEN