DBA Data[Home] [Help]

APPS.CHV_INQ_SV2 dependencies on PO_ASL_ATTRIBUTES_VAL_V

Line 599: FROM po_asl_attributes_val_v paa

595: begin
596:
597: SELECT paa.purchasing_unit_of_measure
598: INTO x_purchasing_unit_of_measure
599: FROM po_asl_attributes_val_v paa
600: WHERE paa.vendor_id = x_vendor_id
601: AND paa.vendor_site_id = x_vendor_site_id
602: AND paa.item_id = x_item_id
603: AND paa.using_organization_id =

Line 605: FROM po_asl_attributes_val_v paa2

601: AND paa.vendor_site_id = x_vendor_site_id
602: AND paa.item_id = x_item_id
603: AND paa.using_organization_id =
604: (SELECT max(paa2.using_organization_id)
605: FROM po_asl_attributes_val_v paa2
606: WHERE decode(paa2.using_organization_id, -1,
607: x_organization_id,
608: paa2.using_organization_id) =
609: x_organization_id