DBA Data[Home] [Help]

APPS.INV_CONSIGN_UTIL dependencies on PO_ASL_STATUS_RULES_V

Line 16: po_asl_status_rules_v pasr

12: CURSOR C is
13: SELECT pasl.asl_id
14: FROM po_approved_supplier_lis_val_v pasl,
15: po_asl_attributes paa,
16: po_asl_status_rules_v pasr
17: WHERE pasl.item_id = p_item_id
18: AND pasl.vendor_id = p_vendor_id
19: AND nvl(pasl.vendor_site_id, -1) = nvl(p_vendor_site_id, -1)
20: AND pasl.using_organization_id IN (-1, p_using_organization_id)