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 2464: from po_asl_attributes_val_v paa

2460:
2461:
2462: select paa.release_generation_method
2463: into x_rel_gen_method
2464: from po_asl_attributes_val_v paa
2465: WHERE (Paa.Item_Id = x_item_id
2466: OR (Paa.Item_Id IS NULL
2467: AND x_category_id = Paa.Category_Id
2468: AND NOT EXISTS (SELECT 'commodity level ASL should be used only if there is no item level ASL'

Line 2469: FROM po_Asl_Attributes_val_v Paa4

2465: WHERE (Paa.Item_Id = x_item_id
2466: OR (Paa.Item_Id IS NULL
2467: AND x_category_id = Paa.Category_Id
2468: AND NOT EXISTS (SELECT 'commodity level ASL should be used only if there is no item level ASL'
2469: FROM po_Asl_Attributes_val_v Paa4
2470: WHERE Paa4.Item_Id = x_item_id
2471: AND Paa4.Vendor_Id = Paa.Vendor_Id
2472: AND Nvl(Paa4.Vendor_Site_Id,- 1) = Nvl(Paa.Vendor_Site_Id,- 1)
2473: AND Paa4.UsIng_Organization_Id IN (- 1,x_organization_id))))

Line 2478: FROM po_Asl_Attributes_val_v Paa3

2474: AND Paa.Vendor_Id = x_suggested_vendor_id
2475: AND (Paa.Vendor_Site_Id IS NULL
2476: OR ( x_suggested_vendor_site_id = Paa.Vendor_Site_Id
2477: AND NOT EXISTS (SELECT 'select supplier line with null supplier site'
2478: FROM po_Asl_Attributes_val_v Paa3
2479: WHERE Nvl(Paa.Item_Id,- 1) = Nvl(Paa3.Item_Id,- 1)
2480: AND Nvl(Paa.Category_Id,- 1) = Nvl(Paa3.Category_Id,- 1)
2481: AND Paa.Vendor_Id = Paa3.Vendor_Id
2482: AND Paa3.Vendor_Site_Id IS NULL

Line 2486: FROM po_Asl_Attributes_val_v Paa2

2482: AND Paa3.Vendor_Site_Id IS NULL
2483: AND Paa3.UsIng_Organization_Id IN (- 1,
2484: x_organization_id))))
2485: AND Paa.UsIng_Organization_Id = (SELECT MAX(Paa2.UsIng_Organization_Id)
2486: FROM po_Asl_Attributes_val_v Paa2
2487: WHERE Nvl(Paa.Item_Id,- 1) = Nvl(Paa2.Item_Id,- 1)
2488: AND Nvl(Paa.Category_Id,- 1) = Nvl(Paa2.Category_Id,- 1)
2489: AND Paa.Vendor_Id = Paa2.Vendor_Id
2490: AND Nvl(Paa.Vendor_Site_Id,- 1) = Nvl(Paa2.Vendor_Site_Id,- 1)

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

2875: l_pcard_id number;
2876: --
2877:
2878:
2879: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE; -- Consigned FPI
2880: l_last_billing_date po_asl_attributes.last_billing_date%TYPE; -- Consigned FPI
2881: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE; -- Consigned FPI
2882:
2883: c2_dest_org_id number; -- Consigned FPI

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

2876: --
2877:
2878:
2879: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE; -- Consigned FPI
2880: l_last_billing_date po_asl_attributes.last_billing_date%TYPE; -- Consigned FPI
2881: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE; -- Consigned FPI
2882:
2883: c2_dest_org_id number; -- Consigned FPI
2884: c2_dest_type_code po_requisition_lines.destination_type_code%TYPE; -- Consigned FPI

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

2877:
2878:
2879: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE; -- Consigned FPI
2880: l_last_billing_date po_asl_attributes.last_billing_date%TYPE; -- Consigned FPI
2881: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE; -- Consigned FPI
2882:
2883: c2_dest_org_id number; -- Consigned FPI
2884: c2_dest_type_code po_requisition_lines.destination_type_code%TYPE; -- Consigned FPI
2885: c2_cons_from_supp_flag varchar2(1); -- Consigned FPI

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

5621: c_item_id number;
5622: c_pcard_id number;
5623: c_contract_id number;
5624:
5625: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE; -- Consigned FPI
5626: l_last_billing_date po_asl_attributes.last_billing_date%TYPE; -- Consigned FPI
5627: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE; -- Consigned FPI
5628:
5629: c_dest_org_id number; -- Consigned FPI

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

5622: c_pcard_id number;
5623: c_contract_id number;
5624:
5625: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE; -- Consigned FPI
5626: l_last_billing_date po_asl_attributes.last_billing_date%TYPE; -- Consigned FPI
5627: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE; -- Consigned FPI
5628:
5629: c_dest_org_id number; -- Consigned FPI
5630: c_dest_type_code po_requisition_lines.destination_type_code%TYPE; -- Consigned FPI

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

5623: c_contract_id number;
5624:
5625: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE; -- Consigned FPI
5626: l_last_billing_date po_asl_attributes.last_billing_date%TYPE; -- Consigned FPI
5627: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE; -- Consigned FPI
5628:
5629: c_dest_org_id number; -- Consigned FPI
5630: c_dest_type_code po_requisition_lines.destination_type_code%TYPE; -- Consigned FPI
5631: c_cons_from_supp_flag varchar2(1); -- Consigned FPI

Line 7190: l_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE;

7186: l_return_status VARCHAR2(1);
7187: l_msg_count NUMBER;
7188: l_msg_data VARCHAR2(2000);
7189: l_error_msg_name VARCHAR2(30);
7190: l_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE;
7191: l_cons_from_supplier_flag VARCHAR2(1);
7192: l_last_billing_date po_asl_attributes.last_billing_date%TYPE;
7193: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE;
7194: BEGIN

Line 7192: l_last_billing_date po_asl_attributes.last_billing_date%TYPE;

7188: l_msg_data VARCHAR2(2000);
7189: l_error_msg_name VARCHAR2(30);
7190: l_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE;
7191: l_cons_from_supplier_flag VARCHAR2(1);
7192: l_last_billing_date po_asl_attributes.last_billing_date%TYPE;
7193: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE;
7194: BEGIN
7195:
7196: l_req_line_id :=

Line 7193: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE;

7189: l_error_msg_name VARCHAR2(30);
7190: l_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE;
7191: l_cons_from_supplier_flag VARCHAR2(1);
7192: l_last_billing_date po_asl_attributes.last_billing_date%TYPE;
7193: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE;
7194: BEGIN
7195:
7196: l_req_line_id :=
7197: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,