DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1551: FROM org_organization_definitions

1547: IF l_material_rec.source_org_id IS NOT NULL THEN
1548: BEGIN
1549: SELECT organization_code ||'-'||organization_name
1550: INTO l_material_rec.trading_partner
1551: FROM org_organization_definitions
1552: WHERE organization_id = l_material_rec.source_org_id;
1553: EXCEPTION
1554: WHEN no_data_found THEN
1555: IF l_debug = 1 THEN

Line 1677: FROM org_organization_definitions

1673: IF l_material_rec.source_org_id IS NOT NULL THEN
1674: BEGIN
1675: SELECT organization_code ||'-'||organization_name
1676: INTO l_material_rec.trading_partner
1677: FROM org_organization_definitions
1678: WHERE organization_id = l_material_rec.source_org_id;
1679: EXCEPTION
1680: WHEN no_data_found THEN
1681: IF l_debug = 1 THEN