DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1488: FROM org_organization_definitions

1484: IF l_material_rec.source_org_id IS NOT NULL THEN
1485: BEGIN
1486: SELECT organization_code ||'-'||organization_name
1487: INTO l_material_rec.trading_partner
1488: FROM org_organization_definitions
1489: WHERE organization_id = l_material_rec.source_org_id;
1490: EXCEPTION
1491: WHEN no_data_found THEN
1492: IF l_debug = 1 THEN

Line 1606: FROM org_organization_definitions

1602: IF l_material_rec.source_org_id IS NOT NULL THEN
1603: BEGIN
1604: SELECT organization_code ||'-'||organization_name
1605: INTO l_material_rec.trading_partner
1606: FROM org_organization_definitions
1607: WHERE organization_id = l_material_rec.source_org_id;
1608: EXCEPTION
1609: WHEN no_data_found THEN
1610: IF l_debug = 1 THEN