DBA Data[Home] [Help]

APPS.CHV_BUILD_SCHEDULES dependencies on CHV_BUCKET_PATTERNS

Line 207: chv_bucket_patterns cbp,

203: paa.vendor_site_id,
204: decode(p_schedule_type, 'PLAN_SCHEDULE', paa.plan_schedule_type,
205: paa.ship_schedule_type)
206: FROM po_asl_attributes_val_v paa,
207: chv_bucket_patterns cbp,
208: po_vendor_sites_all povs
209: WHERE ((paa.using_organization_id = -1 and not exists
210: (SELECT *
211: FROM po_asl_attributes_val_v paa2

Line 367: chv_bucket_patterns cbp

363: CURSOR C_CHECK_BP IS
364: SELECT paa.vendor_id,
365: paa.vendor_site_id
366: FROM po_asl_attributes_val_v paa,
367: chv_bucket_patterns cbp
368: WHERE ((paa.using_organization_id = -1 and not exists
369: (SELECT *
370: FROM po_asl_attributes_val_v paa2
371: WHERE paa2.using_organization_id = x_organization_id