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_INTERFACE_S dependencies on PO_SYSTEM_PARAMETERS_ALL

Line 629: l_req_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;

625: l_api_name VARCHAR2(30) := 'create_documents(wrapper2)'; --< Bug 3210331 >
626: l_return_status VARCHAR2(1);
627: l_msg_count NUMBER;
628: l_msg_data VARCHAR2(2000);
629: l_req_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;
630: l_purch_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;
631: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
632:
633: BEGIN

Line 630: l_purch_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;

626: l_return_status VARCHAR2(1);
627: l_msg_count NUMBER;
628: l_msg_data VARCHAR2(2000);
629: l_req_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;
630: l_purch_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;
631: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
632:
633: BEGIN
634: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 768: l_req_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;

764: --
765: l_api_version CONSTANT NUMBER := 1.0;
766: l_original_operating_unit_id NUMBER;
767: l_org_context_changed VARCHAR2(1) := 'N';
768: l_req_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;
769: l_purch_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;
770:
771: --
772: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >

Line 769: l_purch_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;

765: l_api_version CONSTANT NUMBER := 1.0;
766: l_original_operating_unit_id NUMBER;
767: l_org_context_changed VARCHAR2(1) := 'N';
768: l_req_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;
769: l_purch_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;
770:
771: --
772: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
773:

Line 3390: FROM po_system_parameters_all posp --

3386: into item.inspection_required_flag,
3387: item.receipt_required_flag,
3388: item.invoice_close_tolerance,
3389: item.receive_close_tolerance
3390: FROM po_system_parameters_all posp --
3391: WHERE NVL(org_id, -99) = NVL(g_purchasing_ou_id, -99); --
3392:
3393: Exception
3394: when no_data_found then

Line 4410: FROM po_system_parameters_all posp --

4406: into item.inspection_required_flag,
4407: item.receipt_required_flag,
4408: item.invoice_close_tolerance,
4409: item.receive_close_tolerance
4410: FROM po_system_parameters_all posp --
4411: WHERE NVL(org_id, -99) = NVL(g_purchasing_ou_id, -99); --
4412:
4413: Exception
4414: when no_data_found then

Line 11999: PO_SYSTEM_PARAMETERS_ALL PSP --

11995: SELECT PLL.shipment_num
11996: INTO x_po_shipment_num
11997: FROM PO_LINE_LOCATIONS_ALL PLL, --
11998: PO_REQUISITION_LINES_ALL PRL, --
11999: PO_SYSTEM_PARAMETERS_ALL PSP --
12000: WHERE PLL.LINE_LOCATION_ID = x_line_location_to_check
12001: AND PRL.REQUISITION_LINE_ID = x_requisition_line_id
12002: AND rtrim(nvl(PLL.note_to_receiver,'99')) = rtrim(nvl(x_note_to_receiver,'99'))
12003: AND PLL.SHIPMENT_TYPE in ('STANDARD', 'SCHEDULED',

Line 12070: PO_SYSTEM_PARAMETERS_ALL PSP --

12066: SELECT PLL.shipment_num
12067: INTO x_po_shipment_num
12068: FROM PO_LINE_LOCATIONS_ALL PLL, --
12069: PO_REQUISITION_LINES_ALL PRL, --
12070: PO_SYSTEM_PARAMETERS_ALL PSP --
12071: WHERE PLL.PO_LINE_ID = x_po_line_id
12072: AND PRL.REQUISITION_LINE_ID = x_requisition_line_id
12073: --Bug4599140 (included the following OR condition so that the SQL works correctly
12074: --for null need by date)

Line 12305: po_system_parameters_all psp, --

12301: po_requisition_lines_all prl, --
12302: mtl_system_items msi,
12303: po_line_types plt,
12304: po_vendors pov,
12305: po_system_parameters_all psp, --
12306: financials_system_params_all fsp --
12307: WHERE pli.item_id = msi.inventory_item_id(+)
12308: AND nvl(msi.organization_id,fsp.inventory_organization_id)=
12309: fsp.inventory_organization_id

Line 12367: PO_SYSTEM_PARAMETERS_ALL PSP , --

12363: PO_REQUISITION_LINES_ALL PRL, --
12364: --bug 1942696 hr_location changes to reflect the new view
12365: MTL_SYSTEM_ITEMS MSI ,
12366: PO_LINE_TYPES PLT ,
12367: PO_SYSTEM_PARAMETERS_ALL PSP , --
12368: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
12369: PO_VENDORS POV,
12370: PO_HEADERS_INTERFACE PHI
12371: WHERE PLI.LINE_NUM = x_po_line_num

Line 12488: PO_SYSTEM_PARAMETERS_ALL PSP , --

12484: FROM PO_LINES_INTERFACE PLI,
12485: PO_REQUISITION_LINES_ALL PRL, --
12486: MTL_SYSTEM_ITEMS MSI ,
12487: PO_LINE_TYPES PLT ,
12488: PO_SYSTEM_PARAMETERS_ALL PSP , --
12489: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
12490: PO_VENDORS POV,
12491: PO_HEADERS_INTERFACE PHI
12492: WHERE PLI.LINE_NUM = x_po_line_num

Line 12616: PO_SYSTEM_PARAMETERS_ALL PSP , --

12612: PO_REQUISITION_LINES_ALL PRL, --
12613: --bug 1942696 hr_location changes to reflect the new view
12614: MTL_SYSTEM_ITEMS MSI ,
12615: PO_LINE_TYPES PLT ,
12616: PO_SYSTEM_PARAMETERS_ALL PSP , --
12617: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
12618: PO_VENDORS POV,
12619: PO_HEADERS_INTERFACE PHI
12620: WHERE PLI.LINE_NUM = x_po_line_num

Line 13936: from po_system_parameters_all psp

13932: IF p_rate_type is NULL THEN
13933: l_progress := '020';
13934: select default_rate_type
13935: into l_rate_type
13936: from po_system_parameters_all psp
13937: where psp.org_id = p_purchasing_ou_id; --
13938: ELSE
13939: l_rate_type := p_rate_type;
13940: END IF;