DBA Data[Home] [Help]

APPS.RCV_RMA_TRANSACTIONS dependencies on HR_ALL_ORGANIZATION_UNITS

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

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

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

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