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

Line 94: default_rate_type po_system_parameters.default_rate_type%type,

90: fob_lookup_code financials_system_parameters.fob_lookup_code%type,
91: freight_terms_lookup_code
92: financials_system_parameters.freight_terms_lookup_code%type,
93: terms_id number,
94: default_rate_type po_system_parameters.default_rate_type%type,
95: taxable_flag varchar2(1),
96: receiving_flag varchar2(1),
97: enforce_buyer_name_flag varchar2(1),
98: enforce_buyer_auth_flag varchar2(1),

Line 100: manual_po_num_type po_system_parameters.manual_po_num_type%type,

96: receiving_flag varchar2(1),
97: enforce_buyer_name_flag varchar2(1),
98: enforce_buyer_auth_flag varchar2(1),
99: line_type_id number := null,
100: manual_po_num_type po_system_parameters.manual_po_num_type%type,
101: po_num_code po_system_parameters.user_defined_po_num_code%type,
102: price_type_lookup_code po_system_parameters.price_type_lookup_code%type,
103: invoice_close_tolerance number,
104: receive_close_tolerance number,

Line 101: po_num_code po_system_parameters.user_defined_po_num_code%type,

97: enforce_buyer_name_flag varchar2(1),
98: enforce_buyer_auth_flag varchar2(1),
99: line_type_id number := null,
100: manual_po_num_type po_system_parameters.manual_po_num_type%type,
101: po_num_code po_system_parameters.user_defined_po_num_code%type,
102: price_type_lookup_code po_system_parameters.price_type_lookup_code%type,
103: invoice_close_tolerance number,
104: receive_close_tolerance number,
105: security_structure_id number,

Line 102: price_type_lookup_code po_system_parameters.price_type_lookup_code%type,

98: enforce_buyer_auth_flag varchar2(1),
99: line_type_id number := null,
100: manual_po_num_type po_system_parameters.manual_po_num_type%type,
101: po_num_code po_system_parameters.user_defined_po_num_code%type,
102: price_type_lookup_code po_system_parameters.price_type_lookup_code%type,
103: invoice_close_tolerance number,
104: receive_close_tolerance number,
105: security_structure_id number,
106: expense_accrual_code po_system_parameters.price_type_lookup_code%type,

Line 106: expense_accrual_code po_system_parameters.price_type_lookup_code%type,

102: price_type_lookup_code po_system_parameters.price_type_lookup_code%type,
103: invoice_close_tolerance number,
104: receive_close_tolerance number,
105: security_structure_id number,
106: expense_accrual_code po_system_parameters.price_type_lookup_code%type,
107: inventory_organization_id number,
108: rev_sort_ordering number,
109: min_rel_amount number,
110: notify_blanket_flag varchar2(1),

Line 112: user_defined_req_num_code po_system_parameters.user_defined_req_num_code%type,

108: rev_sort_ordering number,
109: min_rel_amount number,
110: notify_blanket_flag varchar2(1),
111: budgetary_control_flag varchar2(1),
112: user_defined_req_num_code po_system_parameters.user_defined_req_num_code%type,
113: rfq_required_flag varchar2(1),
114: manual_req_num_type po_system_parameters.manual_req_num_type%type,
115: enforce_full_lot_qty po_system_parameters.enforce_full_lot_quantities%type,
116: disposition_warning_flag varchar2(1),

Line 114: manual_req_num_type po_system_parameters.manual_req_num_type%type,

110: notify_blanket_flag varchar2(1),
111: budgetary_control_flag varchar2(1),
112: user_defined_req_num_code po_system_parameters.user_defined_req_num_code%type,
113: rfq_required_flag varchar2(1),
114: manual_req_num_type po_system_parameters.manual_req_num_type%type,
115: enforce_full_lot_qty po_system_parameters.enforce_full_lot_quantities%type,
116: disposition_warning_flag varchar2(1),
117: reserve_at_completion_flag varchar2(1),
118: user_defined_rcpt_num_code

Line 115: enforce_full_lot_qty po_system_parameters.enforce_full_lot_quantities%type,

111: budgetary_control_flag varchar2(1),
112: user_defined_req_num_code po_system_parameters.user_defined_req_num_code%type,
113: rfq_required_flag varchar2(1),
114: manual_req_num_type po_system_parameters.manual_req_num_type%type,
115: enforce_full_lot_qty po_system_parameters.enforce_full_lot_quantities%type,
116: disposition_warning_flag varchar2(1),
117: reserve_at_completion_flag varchar2(1),
118: user_defined_rcpt_num_code
119: po_system_parameters.user_defined_receipt_num_code%type,

Line 119: po_system_parameters.user_defined_receipt_num_code%type,

115: enforce_full_lot_qty po_system_parameters.enforce_full_lot_quantities%type,
116: disposition_warning_flag varchar2(1),
117: reserve_at_completion_flag varchar2(1),
118: user_defined_rcpt_num_code
119: po_system_parameters.user_defined_receipt_num_code%type,
120: manual_rcpt_num_type po_system_parameters.manual_receipt_num_type%type,
121: use_positions_flag varchar2(1),
122: default_quote_warning_delay number,
123: inspection_required_flag varchar2(1),

Line 120: manual_rcpt_num_type po_system_parameters.manual_receipt_num_type%type,

116: disposition_warning_flag varchar2(1),
117: reserve_at_completion_flag varchar2(1),
118: user_defined_rcpt_num_code
119: po_system_parameters.user_defined_receipt_num_code%type,
120: manual_rcpt_num_type po_system_parameters.manual_receipt_num_type%type,
121: use_positions_flag varchar2(1),
122: default_quote_warning_delay number,
123: inspection_required_flag varchar2(1),
124: user_defined_quote_num_code

Line 125: po_system_parameters.user_defined_quote_num_code%type,

121: use_positions_flag varchar2(1),
122: default_quote_warning_delay number,
123: inspection_required_flag varchar2(1),
124: user_defined_quote_num_code
125: po_system_parameters.user_defined_quote_num_code%type,
126: manual_quote_num_type po_system_parameters.manual_quote_num_type%type,
127: user_defined_rfq_num_code
128: po_system_parameters.user_defined_rfq_num_code%type,
129: manual_rfq_num_type po_system_parameters.manual_rfq_num_type%type,

Line 126: manual_quote_num_type po_system_parameters.manual_quote_num_type%type,

122: default_quote_warning_delay number,
123: inspection_required_flag varchar2(1),
124: user_defined_quote_num_code
125: po_system_parameters.user_defined_quote_num_code%type,
126: manual_quote_num_type po_system_parameters.manual_quote_num_type%type,
127: user_defined_rfq_num_code
128: po_system_parameters.user_defined_rfq_num_code%type,
129: manual_rfq_num_type po_system_parameters.manual_rfq_num_type%type,
130: ship_via_lookup_code financials_system_parameters.ship_via_lookup_code%type,

Line 128: po_system_parameters.user_defined_rfq_num_code%type,

124: user_defined_quote_num_code
125: po_system_parameters.user_defined_quote_num_code%type,
126: manual_quote_num_type po_system_parameters.manual_quote_num_type%type,
127: user_defined_rfq_num_code
128: po_system_parameters.user_defined_rfq_num_code%type,
129: manual_rfq_num_type po_system_parameters.manual_rfq_num_type%type,
130: ship_via_lookup_code financials_system_parameters.ship_via_lookup_code%type,
131: qty_rcv_tolerance number,
132: period_name gl_period_statuses.period_name%type,

Line 129: manual_rfq_num_type po_system_parameters.manual_rfq_num_type%type,

125: po_system_parameters.user_defined_quote_num_code%type,
126: manual_quote_num_type po_system_parameters.manual_quote_num_type%type,
127: user_defined_rfq_num_code
128: po_system_parameters.user_defined_rfq_num_code%type,
129: manual_rfq_num_type po_system_parameters.manual_rfq_num_type%type,
130: ship_via_lookup_code financials_system_parameters.ship_via_lookup_code%type,
131: qty_rcv_tolerance number,
132: period_name gl_period_statuses.period_name%type,
133: acceptance_required_flag po_system_parameters.acceptance_required_flag%type); /* Bug 7518967 : Default Acceptance Required Check ER */

Line 133: acceptance_required_flag po_system_parameters.acceptance_required_flag%type); /* Bug 7518967 : Default Acceptance Required Check ER */

129: manual_rfq_num_type po_system_parameters.manual_rfq_num_type%type,
130: ship_via_lookup_code financials_system_parameters.ship_via_lookup_code%type,
131: qty_rcv_tolerance number,
132: period_name gl_period_statuses.period_name%type,
133: acceptance_required_flag po_system_parameters.acceptance_required_flag%type); /* Bug 7518967 : Default Acceptance Required Check ER */
134:
135: --
136: TYPE po_line_id_tbl IS TABLE OF PO_LINES_ALL.po_line_id%TYPE INDEX BY PLS_INTEGER;
137: TYPE interface_header_id_tbl IS TABLE OF PO_ATTR_VALUES_INTERFACE.interface_header_id%TYPE INDEX BY PLS_INTEGER;

Line 626: l_req_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;

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

Line 627: l_purch_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;

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

Line 864: l_req_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;

860: --
861: l_api_version CONSTANT NUMBER := 1.0;
862: l_original_operating_unit_id NUMBER;
863: l_org_context_changed VARCHAR2(1) := 'N';
864: l_req_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;
865: l_purch_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;
866:
867: --
868: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >

Line 865: l_purch_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;

861: l_api_version CONSTANT NUMBER := 1.0;
862: l_original_operating_unit_id NUMBER;
863: l_org_context_changed VARCHAR2(1) := 'N';
864: l_req_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;
865: l_purch_operating_unit_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;
866:
867: --
868: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
869:

Line 3739: also from po system parameters if not defined at above level

3735: l_progress := '190';
3736:
3737: /* Bug: 1322342 Select receipt required flag,inspection required flag
3738: receipt close tolerance and insp close tolerance
3739: also from po system parameters if not defined at above level
3740: */
3741: Begin
3742: select nvl(item.inspection_required_flag,
3743: posp.INSPECTION_REQUIRED_FLAG),

Line 3754: FROM po_system_parameters_all posp --

3750: into item.inspection_required_flag,
3751: item.receipt_required_flag,
3752: item.invoice_close_tolerance,
3753: item.receive_close_tolerance
3754: FROM po_system_parameters_all posp --
3755: WHERE NVL(org_id, -99) = NVL(g_purchasing_ou_id, -99); --
3756:
3757: Exception
3758: when no_data_found then

Line 4822: also from po system parameters if not defined at above level

4818: l_progress := '500';
4819:
4820: /* Bug: 1322342 Select receipt required flag,inspection required flag
4821: receipt close tolerance and insp close tolerance
4822: also from po system parameters if not defined at above level
4823: */
4824: Begin
4825: select nvl(item.inspection_required_flag,
4826: posp.INSPECTION_REQUIRED_FLAG),

Line 4837: FROM po_system_parameters_all posp --

4833: into item.inspection_required_flag,
4834: item.receipt_required_flag,
4835: item.invoice_close_tolerance,
4836: item.receive_close_tolerance
4837: FROM po_system_parameters_all posp --
4838: WHERE NVL(org_id, -99) = NVL(g_purchasing_ou_id, -99); --
4839:
4840: Exception
4841: when no_data_found then

Line 12721: PO_SYSTEM_PARAMETERS_ALL PSP --

12717: SELECT PLL.shipment_num
12718: INTO x_po_shipment_num
12719: FROM PO_LINE_LOCATIONS_ALL PLL, --
12720: PO_REQUISITION_LINES_ALL PRL, --
12721: PO_SYSTEM_PARAMETERS_ALL PSP --
12722: WHERE PLL.LINE_LOCATION_ID = x_line_location_to_check
12723: AND PRL.REQUISITION_LINE_ID = x_requisition_line_id
12724: AND rtrim(nvl(PLL.note_to_receiver,'99')) = rtrim(nvl(x_note_to_receiver,'99'))
12725: AND PLL.SHIPMENT_TYPE in ('STANDARD', 'SCHEDULED',

Line 12792: PO_SYSTEM_PARAMETERS_ALL PSP --

12788: SELECT PLL.shipment_num
12789: INTO x_po_shipment_num
12790: FROM PO_LINE_LOCATIONS_ALL PLL, --
12791: PO_REQUISITION_LINES_ALL PRL, --
12792: PO_SYSTEM_PARAMETERS_ALL PSP --
12793: WHERE PLL.PO_LINE_ID = x_po_line_id
12794: AND PRL.REQUISITION_LINE_ID = x_requisition_line_id
12795: --Bug4599140 (included the following OR condition so that the SQL works correctly
12796: --for null need by date)

Line 13027: po_system_parameters_all psp, --

13023: po_requisition_lines_all prl, --
13024: mtl_system_items msi,
13025: po_line_types plt,
13026: po_vendors pov,
13027: po_system_parameters_all psp, --
13028: financials_system_params_all fsp --
13029: WHERE pli.item_id = msi.inventory_item_id(+)
13030: AND nvl(msi.organization_id,fsp.inventory_organization_id)=
13031: fsp.inventory_organization_id

Line 13089: PO_SYSTEM_PARAMETERS_ALL PSP , --

13085: PO_REQUISITION_LINES_ALL PRL, --
13086: --bug 1942696 hr_location changes to reflect the new view
13087: MTL_SYSTEM_ITEMS MSI ,
13088: PO_LINE_TYPES PLT ,
13089: PO_SYSTEM_PARAMETERS_ALL PSP , --
13090: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
13091: PO_VENDORS POV,
13092: PO_HEADERS_INTERFACE PHI
13093: WHERE PLI.LINE_NUM = x_po_line_num

Line 13210: PO_SYSTEM_PARAMETERS_ALL PSP , --

13206: FROM PO_LINES_INTERFACE PLI,
13207: PO_REQUISITION_LINES_ALL PRL, --
13208: MTL_SYSTEM_ITEMS MSI ,
13209: PO_LINE_TYPES PLT ,
13210: PO_SYSTEM_PARAMETERS_ALL PSP , --
13211: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
13212: PO_VENDORS POV,
13213: PO_HEADERS_INTERFACE PHI
13214: WHERE PLI.LINE_NUM = x_po_line_num

Line 13338: PO_SYSTEM_PARAMETERS_ALL PSP , --

13334: PO_REQUISITION_LINES_ALL PRL, --
13335: --bug 1942696 hr_location changes to reflect the new view
13336: MTL_SYSTEM_ITEMS MSI ,
13337: PO_LINE_TYPES PLT ,
13338: PO_SYSTEM_PARAMETERS_ALL PSP , --
13339: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
13340: PO_VENDORS POV,
13341: PO_HEADERS_INTERFACE PHI
13342: WHERE PLI.LINE_NUM = x_po_line_num

Line 13431: FROM po_system_parameters_all psp

13427:
13428: IF (x_group_shipments IS NULL) THEN
13429: SELECT psp.group_shipments_flag
13430: INTO l_group_shipments
13431: FROM po_system_parameters_all psp
13432: where NVL(psp.org_id, -99) = NVL(g_purchasing_ou_id, -99);
13433: ELSE
13434: l_group_shipments := x_group_shipments;
13435: END IF;

Line 14842: from po_system_parameters_all psp

14838: IF p_rate_type is NULL THEN
14839: l_progress := '020';
14840: select default_rate_type
14841: into l_rate_type
14842: from po_system_parameters_all psp
14843: where psp.org_id = p_purchasing_ou_id; --
14844: ELSE
14845: l_rate_type := p_rate_type;
14846: END IF;