eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AUTOCREATE_DOC dependencies on PO_ASL_ATTRIBUTES_VAL_V

Line 2685: from po_asl_attributes_val_v paa

2681: select release_generation_method
2682: into x_rel_gen_method
2683: from (
2684: select paa.release_generation_method
2685: from po_asl_attributes_val_v paa
2686: WHERE Paa.Item_Id = x_item_id
2687: AND Paa.Vendor_Id = x_suggested_vendor_id
2688: AND (Paa.Vendor_Site_Id IS NULL
2689: OR ( x_suggested_vendor_site_id = Paa.Vendor_Site_Id

Line 2691: FROM po_Asl_Attributes_val_v Paa3

2687: AND Paa.Vendor_Id = x_suggested_vendor_id
2688: AND (Paa.Vendor_Site_Id IS NULL
2689: OR ( x_suggested_vendor_site_id = Paa.Vendor_Site_Id
2690: AND NOT EXISTS (SELECT 'select supplier line with null supplier site'
2691: FROM po_Asl_Attributes_val_v Paa3
2692: WHERE Paa.Item_Id = Paa3.Item_Id
2693: AND Nvl(Paa.Category_Id,- 1) = Nvl(Paa3.Category_Id,- 1)
2694: AND Paa.Vendor_Id = Paa3.Vendor_Id
2695: AND Paa3.Vendor_Site_Id IS NULL

Line 2699: FROM po_Asl_Attributes_val_v Paa2

2695: AND Paa3.Vendor_Site_Id IS NULL
2696: AND Paa3.UsIng_Organization_Id IN (- 1,
2697: x_organization_id))))
2698: AND Paa.UsIng_Organization_Id = (SELECT MAX(Paa2.UsIng_Organization_Id)
2699: FROM po_Asl_Attributes_val_v Paa2
2700: WHERE Paa.Item_Id = Paa2.Item_Id
2701: AND Nvl(Paa.Category_Id,- 1) = Nvl(Paa2.Category_Id,- 1)
2702: AND Paa.Vendor_Id = Paa2.Vendor_Id
2703: AND Nvl(Paa.Vendor_Site_Id,- 1) = Nvl(Paa2.Vendor_Site_Id,- 1)

Line 2707: from po_asl_attributes_val_v paa

2703: AND Nvl(Paa.Vendor_Site_Id,- 1) = Nvl(Paa2.Vendor_Site_Id,- 1)
2704: AND Paa2.UsIng_Organization_Id IN (- 1,x_organization_id))
2705: union all
2706: select paa.release_generation_method
2707: from po_asl_attributes_val_v paa
2708: WHERE (Paa.Item_Id IS NULL
2709: AND x_category_id = Paa.Category_Id
2710: AND NOT EXISTS (SELECT 'commodity level ASL should be used only if there is no item level ASL'
2711: FROM po_Asl_Attributes_val_v Paa4

Line 2711: FROM po_Asl_Attributes_val_v Paa4

2707: from po_asl_attributes_val_v paa
2708: WHERE (Paa.Item_Id IS NULL
2709: AND x_category_id = Paa.Category_Id
2710: AND NOT EXISTS (SELECT 'commodity level ASL should be used only if there is no item level ASL'
2711: FROM po_Asl_Attributes_val_v Paa4
2712: WHERE Paa4.Item_Id = x_item_id
2713: AND Paa4.Vendor_Id = Paa.Vendor_Id
2714: AND Nvl(Paa4.Vendor_Site_Id,- 1) = Nvl(Paa.Vendor_Site_Id,- 1)
2715: AND Paa4.UsIng_Organization_Id IN (- 1,x_organization_id)))

Line 2720: FROM po_Asl_Attributes_val_v Paa3

2716: AND Paa.Vendor_Id = x_suggested_vendor_id
2717: AND (Paa.Vendor_Site_Id IS NULL
2718: OR ( x_suggested_vendor_site_id = Paa.Vendor_Site_Id
2719: AND NOT EXISTS (SELECT 'select supplier line with null supplier site'
2720: FROM po_Asl_Attributes_val_v Paa3
2721: WHERE Paa3.Item_Id IS NULL
2722: AND Paa.Category_Id = Paa3.Category_Id
2723: AND Paa.Vendor_Id = Paa3.Vendor_Id
2724: AND Paa3.Vendor_Site_Id IS NULL

Line 2728: FROM po_Asl_Attributes_val_v Paa2

2724: AND Paa3.Vendor_Site_Id IS NULL
2725: AND Paa3.UsIng_Organization_Id IN (- 1,
2726: x_organization_id))))
2727: AND Paa.UsIng_Organization_Id = (SELECT MAX(Paa2.UsIng_Organization_Id)
2728: FROM po_Asl_Attributes_val_v Paa2
2729: WHERE Paa2.Item_Id IS NULL
2730: AND Paa.Category_Id = Paa2.Category_Id
2731: AND Paa.Vendor_Id = Paa2.Vendor_Id
2732: AND Nvl(Paa.Vendor_Site_Id,- 1) = Nvl(Paa2.Vendor_Site_Id,- 1)