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 767: FROM po_approved_supplier_lis_val_v pasl,

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

Line 3827: FROM po_approved_supplier_lis_val_v pasl,

3823: -- po_vendor_sites_all using vendor_site_id
3824: SELECT pasl.asl_id, paa.using_organization_id,
3825: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
3826: paa.consigned_from_supplier_flag, paa.enable_vmi_flag
3827: FROM po_approved_supplier_lis_val_v pasl,
3828: po_asl_attributes paa,
3829: po_asl_status_rules_v pasr,
3830: po_vendor_sites_all pvs
3831: WHERE pasl.item_id = p_item_id --

Line 3868: FROM po_approved_supplier_lis_val_v pasl,

3864: SELECT pasl.asl_id, paa.using_organization_id,
3865: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
3866: paa.consigned_from_supplier_flag, paa.enable_vmi_flag,
3867: pad.sequence_num
3868: FROM po_approved_supplier_lis_val_v pasl,
3869: po_asl_attributes paa,
3870: po_asl_status_rules_v pasr,
3871: po_asl_documents pad,
3872: po_headers_all poh,

Line 4202: FROM po_approved_supplier_lis_val_v pasl,

4198: -- po_vendor_sites_all using vendor_site_id
4199: SELECT pasl.asl_id, paa.using_organization_id,
4200: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
4201: paa.consigned_from_supplier_flag, paa.enable_vmi_flag
4202: FROM po_approved_supplier_lis_val_v pasl,
4203: po_asl_attributes paa,
4204: po_asl_status_rules_v pasr,
4205: po_vendor_sites_all pvs
4206: WHERE pasl.category_id = p_category_id --

Line 4241: FROM po_approved_supplier_lis_val_v pasl,

4237: SELECT pasl.asl_id, paa.using_organization_id,
4238: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
4239: paa.consigned_from_supplier_flag, paa.enable_vmi_flag,
4240: pad.sequence_num
4241: FROM po_approved_supplier_lis_val_v pasl,
4242: po_asl_attributes paa,
4243: po_asl_status_rules_v pasr,
4244: po_asl_documents pad,
4245: po_headers_all poh,

Line 5258: FROM po_approved_supplier_lis_val_v

5254: Begin
5255:
5256: SELECT primary_vendor_item
5257: INTO x_vendor_product_num
5258: FROM po_approved_supplier_lis_val_v
5259: WHERE asl_id = l_asl_id;
5260:
5261: Exception
5262: When Others Then

Line 5559: FROM po_approved_supplier_lis_val_v pasl,

5555: pasl.vendor_site_id,
5556: pasl.asl_id,
5557: pasl.primary_vendor_item,
5558: paa.purchasing_unit_of_measure
5559: FROM po_approved_supplier_lis_val_v pasl,
5560: po_asl_attributes paa,
5561: po_asl_status_rules_v pasr
5562: WHERE pasl.item_id = x_item_id
5563: AND (pasl.using_organization_id IN