DBA Data[Home] [Help]

APPS.MRP_EPI dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 31: org_organization_definitions org,

27: p_plan_start_date,start_date) start_date,
28: DECODE(GREATEST(end_date,p_plan_end_date),end_date,
29: p_plan_end_date,end_date) end_date
30: FROM gl_periods cal,
31: org_organization_definitions org,
32: gl_sets_of_books sb
33: WHERE org.set_of_books_id = sb.set_of_books_id
34: AND sb.period_set_name = cal.period_set_name
35: AND sb.accounted_period_type = cal.period_type

Line 684: FROM org_organization_definitions org,

680: sum(md.completed_quantity) *
681: mrp_epi.mrp_item_selling_price(dates.inventory_item_id,
682: dates.organization_id),
683: avg(dates.confidence_percentage)
684: FROM org_organization_definitions org,
685: fnd_lookup_values ar,
686: --ar_lookups ar, --bug2384395
687: HZ_PARTIES PART, /*bug4434875*/
688: HZ_CUST_ACCOUNTS CA,

Line 981: FROM org_organization_definitions org,

977: dates.organization_id),
978: 0,
979: 0,
980: dates.confidence_percentage
981: FROM org_organization_definitions org,
982: fnd_lookup_values ar,
983: --ar_lookups ar, --bug2384395
984: HZ_PARTIES PART, /*bug4434875*/
985: HZ_CUST_ACCOUNTS CA,