DBA Data[Home] [Help]

APPS.CSP_EXCESS_PARTS_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 338: from org_organization_definitions

334: l_operating_unit number;
335: begin
336: select operating_unit, substr(organization_name,1,30), operating_unit
337: into l_operating_unit, l_org_name, l_po_org_id
338: from org_organization_definitions
339: where organization_id = p_organization_id;
340:
341: select nvl(req_encumbrance_flag, 'N')
342: into l_encum_flag

Line 2749: org_organization_definitions ood

2745: ood.operating_unit
2746: from csp_return_routing_rules crrr,
2747: hr_organization_units hoa,
2748: csp_planning_parameters cpp,
2749: org_organization_definitions ood
2750: where crrr.rule_id = p_return_rule_id
2751: and crrr.dest_subinv is null
2752: and crrr.dest_org_id = hoa.organization_id
2753: and ood.organization_id = hoa.organization_id

Line 2765: org_organization_definitions ood

2761: ood.operating_unit
2762: from csp_return_routing_rules crrr,
2763: mtl_secondary_inventories msi,
2764: csp_planning_parameters cpp,
2765: org_organization_definitions ood
2766: where crrr.rule_id = p_return_rule_id
2767: and crrr.dest_org_id = msi.organization_id
2768: and crrr.dest_subinv = msi.secondary_inventory_name
2769: and ood.organization_id = msi.organization_id