APPS.PO_AUTOSOURCE_SV dependencies on PO_APPROVED_SUPPLIER_LIS_VAL_V

Line 726: FROM po_approved_supplier_lis_val_v pasl,

722: paa.vmi_min_qty,
723: paa.vmi_max_qty,
724: paa.enable_vmi_auto_replenish_flag,
725: paa.vmi_replenishment_approval
726: FROM po_approved_supplier_lis_val_v pasl,
727: po_asl_attributes paa,
728: po_asl_status_rules_v pasr
729: WHERE pasl.item_id = x_item_id --
730: AND pasl.vendor_id = x_vendor_id

Line 765: FROM po_approved_supplier_lis_val_v pasl,

761: paa.vmi_min_qty,
762: paa.vmi_max_qty,
763: paa.enable_vmi_auto_replenish_flag,
764: paa.vmi_replenishment_approval
765: FROM po_approved_supplier_lis_val_v pasl,
766: po_asl_attributes paa,
767: po_asl_status_rules_v pasr
768: WHERE pasl.category_id = p_category_id --
769: AND pasl.vendor_id = x_vendor_id

Line 3801: FROM po_approved_supplier_lis_val_v pasl,

3797: -- po_vendor_sites_all using vendor_site_id
3798: SELECT pasl.asl_id, paa.using_organization_id,
3799: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
3800: paa.consigned_from_supplier_flag, paa.enable_vmi_flag
3801: FROM po_approved_supplier_lis_val_v pasl,
3802: po_asl_attributes paa,
3803: po_asl_status_rules_v pasr,
3804: po_vendor_sites_all pvs
3805: WHERE pasl.item_id = p_item_id --

Line 3840: FROM po_approved_supplier_lis_val_v pasl,

3836: SELECT pasl.asl_id, paa.using_organization_id,
3837: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
3838: paa.consigned_from_supplier_flag, paa.enable_vmi_flag,
3839: pad.sequence_num
3840: FROM po_approved_supplier_lis_val_v pasl,
3841: po_asl_attributes paa,
3842: po_asl_status_rules_v pasr,
3843: po_asl_documents pad,
3844: po_headers_all poh,

Line 4174: FROM po_approved_supplier_lis_val_v pasl,

4170: -- po_vendor_sites_all using vendor_site_id
4171: SELECT pasl.asl_id, paa.using_organization_id,
4172: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
4173: paa.consigned_from_supplier_flag, paa.enable_vmi_flag
4174: FROM po_approved_supplier_lis_val_v pasl,
4175: po_asl_attributes paa,
4176: po_asl_status_rules_v pasr,
4177: po_vendor_sites_all pvs
4178: WHERE pasl.category_id = p_category_id --

Line 4213: FROM po_approved_supplier_lis_val_v pasl,

4209: SELECT pasl.asl_id, paa.using_organization_id,
4210: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
4211: paa.consigned_from_supplier_flag, paa.enable_vmi_flag,
4212: pad.sequence_num
4213: FROM po_approved_supplier_lis_val_v pasl,
4214: po_asl_attributes paa,
4215: po_asl_status_rules_v pasr,
4216: po_asl_documents pad,
4217: po_headers_all poh,

Line 5482: FROM po_approved_supplier_lis_val_v pasl,

5478: pasl.vendor_site_id,
5479: pasl.asl_id,
5480: pasl.primary_vendor_item,
5481: paa.purchasing_unit_of_measure
5482: FROM po_approved_supplier_lis_val_v pasl,
5483: po_asl_attributes paa,
5484: po_asl_status_rules_v pasr
5485: WHERE pasl.item_id = x_item_id
5486: AND (pasl.using_organization_id IN