DBA Data[Home] [Help]

APPS.CHV_CONFIRM_SCHEDULES dependencies on PO_ASL_ATTRIBUTES_VAL_V

Line 270: FROM po_asl_attributes_val_v paa

266: paa.enable_authorizations_flag
267: INTO x_dummy_org,
268: x_asl_id,
269: x_enable_authorization_flag
270: FROM po_asl_attributes_val_v paa
271: WHERE ((paa.using_organization_id = -1 and not exists
272: (SELECT *
273: FROM po_asl_attributes_val_v paa2
274: WHERE paa2.using_organization_id = x_item_org_id

Line 273: FROM po_asl_attributes_val_v paa2

269: x_enable_authorization_flag
270: FROM po_asl_attributes_val_v paa
271: WHERE ((paa.using_organization_id = -1 and not exists
272: (SELECT *
273: FROM po_asl_attributes_val_v paa2
274: WHERE paa2.using_organization_id = x_item_org_id
275: AND paa2.vendor_id = x_vendor_id
276: AND paa2.vendor_site_id = x_vendor_site_id
277: AND paa2.item_id = x_item_id))