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

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)

Line 3122: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE; -- Consigned FPI

3118: l_pcard_id number;
3119: --
3120:
3121:
3122: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE; -- Consigned FPI
3123: l_last_billing_date po_asl_attributes.last_billing_date%TYPE; -- Consigned FPI
3124: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE; -- Consigned FPI
3125:
3126: c2_dest_org_id number; -- Consigned FPI

Line 3123: l_last_billing_date po_asl_attributes.last_billing_date%TYPE; -- Consigned FPI

3119: --
3120:
3121:
3122: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE; -- Consigned FPI
3123: l_last_billing_date po_asl_attributes.last_billing_date%TYPE; -- Consigned FPI
3124: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE; -- Consigned FPI
3125:
3126: c2_dest_org_id number; -- Consigned FPI
3127: c2_dest_type_code po_requisition_lines.destination_type_code%TYPE; -- Consigned FPI

Line 3124: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE; -- Consigned FPI

3120:
3121:
3122: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE; -- Consigned FPI
3123: l_last_billing_date po_asl_attributes.last_billing_date%TYPE; -- Consigned FPI
3124: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE; -- Consigned FPI
3125:
3126: c2_dest_org_id number; -- Consigned FPI
3127: c2_dest_type_code po_requisition_lines.destination_type_code%TYPE; -- Consigned FPI
3128: c2_cons_from_supp_flag varchar2(1); -- Consigned FPI

Line 6006: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE; -- Consigned FPI

6002: c_item_id number;
6003: c_pcard_id number;
6004: c_contract_id number;
6005:
6006: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE; -- Consigned FPI
6007: l_last_billing_date po_asl_attributes.last_billing_date%TYPE; -- Consigned FPI
6008: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE; -- Consigned FPI
6009:
6010: c_dest_org_id number; -- Consigned FPI

Line 6007: l_last_billing_date po_asl_attributes.last_billing_date%TYPE; -- Consigned FPI

6003: c_pcard_id number;
6004: c_contract_id number;
6005:
6006: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE; -- Consigned FPI
6007: l_last_billing_date po_asl_attributes.last_billing_date%TYPE; -- Consigned FPI
6008: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE; -- Consigned FPI
6009:
6010: c_dest_org_id number; -- Consigned FPI
6011: c_dest_type_code po_requisition_lines.destination_type_code%TYPE; -- Consigned FPI

Line 6008: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE; -- Consigned FPI

6004: c_contract_id number;
6005:
6006: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE; -- Consigned FPI
6007: l_last_billing_date po_asl_attributes.last_billing_date%TYPE; -- Consigned FPI
6008: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE; -- Consigned FPI
6009:
6010: c_dest_org_id number; -- Consigned FPI
6011: c_dest_type_code po_requisition_lines.destination_type_code%TYPE; -- Consigned FPI
6012: c_cons_from_supp_flag varchar2(1); -- Consigned FPI

Line 7643: l_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE;

7639: l_return_status VARCHAR2(1);
7640: l_msg_count NUMBER;
7641: l_msg_data VARCHAR2(2000);
7642: l_error_msg_name VARCHAR2(30);
7643: l_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE;
7644: l_cons_from_supplier_flag VARCHAR2(1);
7645: l_last_billing_date po_asl_attributes.last_billing_date%TYPE;
7646: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE;
7647: BEGIN

Line 7645: l_last_billing_date po_asl_attributes.last_billing_date%TYPE;

7641: l_msg_data VARCHAR2(2000);
7642: l_error_msg_name VARCHAR2(30);
7643: l_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE;
7644: l_cons_from_supplier_flag VARCHAR2(1);
7645: l_last_billing_date po_asl_attributes.last_billing_date%TYPE;
7646: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE;
7647: BEGIN
7648:
7649: l_req_line_id :=

Line 7646: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE;

7642: l_error_msg_name VARCHAR2(30);
7643: l_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE;
7644: l_cons_from_supplier_flag VARCHAR2(1);
7645: l_last_billing_date po_asl_attributes.last_billing_date%TYPE;
7646: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE;
7647: BEGIN
7648:
7649: l_req_line_id :=
7650: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,