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 MTL_SYSTEM_ITEMS

Line 15: MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE

11: ;
12:
13: --
14: g_chktype_TRACKING_QTY_IND CONSTANT
15: MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE
16: := 'PS';
17:
18: --
19: g_ATTR_VALUES_NULL_ID CONSTANT NUMBER := PO_ATTRIBUTE_VALUES_PVT.g_ATTR_VALUES_NULL_ID;

Line 2711: x_ship_to_loc_org_id mtl_system_items.organization_id%TYPE;

2707: x_description ap_tax_codes.description%type;
2708: x_allow_tax_code_override_flag gl_tax_option_accounts.allow_tax_code_override_flag%type;
2709: x_tax_name po_lines.tax_name%type;
2710: x_ship_to_location_id number:= 0;
2711: x_ship_to_loc_org_id mtl_system_items.organization_id%TYPE;
2712: x_ship_org_code varchar2(3);
2713:
2714: /** **/
2715: /** tpoon 9/29/2002 **/

Line 2734: x_inv_org_id mtl_system_items.organization_id%TYPE;

2730: x_retvar BOOLEAN;
2731: ic_item_mst_rec IC_ITEM_MST%ROWTYPE;
2732: ic_item_cpg_rec IC_ITEM_CPG%ROWTYPE;
2733: x_order_opm_um ic_item_mst.item_um%type := NULL;
2734: x_inv_org_id mtl_system_items.organization_id%TYPE;
2735: **/
2736: l_api_name CONSTANT VARCHAR2(30) := 'create_line';
2737: d_mod CONSTANT VARCHAR2(255) := g_log_head||l_api_name;
2738: -- end of 2219743

Line 3056: FROM mtl_system_items

3052: BEGIN
3053: l_progress := '080';
3054: SELECT segment1
3055: INTO x_item_number
3056: FROM mtl_system_items
3057: WHERE
3058: inventory_item_id = interface.item_id
3059: AND organization_id = x_inv_org_id;
3060:

Line 3223: FROM mtl_system_items msi

3219: INTO item.invoice_close_tolerance,
3220: item.receive_close_tolerance,
3221: item.inspection_required_flag,
3222: item.receipt_required_flag
3223: FROM mtl_system_items msi
3224: WHERE msi.inventory_item_id = interface.item_id
3225: AND msi.organization_id = interface.destination_organization_id;
3226:
3227: exception

Line 3273: FROM mtl_system_items msi

3269: item.invoice_close_tolerance,
3270: item.receive_close_tolerance,
3271: item.secondary_uom_code, --
3272: item.grade_control_flag --
3273: FROM mtl_system_items msi
3274: WHERE msi.inventory_item_id = interface.item_id
3275: AND msi.organization_id = params.inventory_organization_id;
3276:
3277: exception

Line 3628: from mtl_system_items

3624: begin
3625: l_progress:='270';
3626: select un_number_id,hazard_class_id
3627: into x_un_number_id,x_hazard_class_id
3628: from mtl_system_items
3629: where inventory_item_id = interface.item_id
3630: and organization_id =params.inventory_organization_id;
3631: exception
3632: when no_data_found then

Line 4266: FROM mtl_system_items msi

4262: INTO item.invoice_close_tolerance,
4263: item.receive_close_tolerance,
4264: item.receipt_required_flag,
4265: item.inspection_required_flag
4266: FROM mtl_system_items msi
4267: WHERE msi.inventory_item_id = interface.item_id
4268: AND msi.organization_id = interface.destination_organization_id;
4269:
4270: exception

Line 4301: FROM mtl_system_items msi

4297: item.receive_close_tolerance,
4298: item.receipt_required_flag,
4299: item.inspection_required_flag,
4300: item.secondary_uom_code --
4301: FROM mtl_system_items msi
4302: WHERE msi.inventory_item_id = interface.item_id
4303: AND msi.organization_id = params.inventory_organization_id;
4304: exception
4305: when no_data_found then

Line 5231: x_item_org_taxable_flag mtl_system_items.taxable_flag%type := NULL;

5227: x_price number; /* used to get release price from PA */
5228: x_price_break_type varchar2(25) := '';
5229: x_doctype varchar2(25) := ''; /* used for call to update close state */
5230: x_return_code varchar2(25) := ''; /* used for call to update close state */
5231: x_item_org_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5232: x_ship_to_org_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5233: x_return_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5234:
5235: /* For converting qty if line_type is not quantity based */

Line 5232: x_ship_to_org_taxable_flag mtl_system_items.taxable_flag%type := NULL;

5228: x_price_break_type varchar2(25) := '';
5229: x_doctype varchar2(25) := ''; /* used for call to update close state */
5230: x_return_code varchar2(25) := ''; /* used for call to update close state */
5231: x_item_org_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5232: x_ship_to_org_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5233: x_return_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5234:
5235: /* For converting qty if line_type is not quantity based */
5236: x_order_type_lookup_code varchar2(25) :='';

Line 5233: x_return_taxable_flag mtl_system_items.taxable_flag%type := NULL;

5229: x_doctype varchar2(25) := ''; /* used for call to update close state */
5230: x_return_code varchar2(25) := ''; /* used for call to update close state */
5231: x_item_org_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5232: x_ship_to_org_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5233: x_return_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5234:
5235: /* For converting qty if line_type is not quantity based */
5236: x_order_type_lookup_code varchar2(25) :='';
5237: x_quantity number :=0;

Line 9998: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE;

9994:
9995: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
9996:
9997: --
9998: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE;
9999: l_line_grade MTL_GRADES.GRADE_CODE%TYPE;
10000: --
10001:
10002: l_max_iface_line_num NUMBER; --

Line 10838: FROM mtl_system_items

10834:
10835: BEGIN
10836: SELECT grade_control_flag
10837: INTO l_grade_control_flag
10838: FROM mtl_system_items
10839: WHERE inventory_item_id = x_item_id
10840: and organization_id = params.inventory_organization_id;
10841: EXCEPTION
10842: WHEN OTHERS THEN

Line 12279: mtl_system_items when Checking for Item details. */

12275: /* Bug # 2224446, Autocreate was not grouping Req. lines when two req.
12276: with the same line details was entered. This happened when they don't
12277: Enter a Item in the lines block. We were not considering that the Item
12278: can be NULL when grouping shipment line. Used outer join on
12279: mtl_system_items when Checking for Item details. */
12280:
12281: --
12282: --As per the HLD.
12283: --Only Requisition grouping will be available for the new Service line types.

Line 12302: mtl_system_items msi,

12298: INTO x_receipt_required_flag
12299: FROM po_lines_interface pli,
12300: po_headers_interface phi,
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 --

Line 12348: /* Bug # 2224446, Added outer join on mtl_system_items */

12344: /*
12345: ** See if a record that has just been inserted into the
12346: ** interface table matches the shipment you are trying to create.
12347: */
12348: /* Bug # 2224446, Added outer join on mtl_system_items */
12349: /* Bug: 2348161.Changed the below SQL and removed the reference to the tables
12350: HZ_LOCATIONS and HR_LOCATIONS and also the corresponding where
12351: clause. Instead added a subquery to check for the location_id
12352: to improve the performance

Line 12365: MTL_SYSTEM_ITEMS MSI ,

12361: ,x_req_line_to_check
12362: FROM PO_LINES_INTERFACE PLI,
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,

Line 12486: MTL_SYSTEM_ITEMS MSI ,

12482: SELECT PLI.shipment_num
12483: INTO x_po_shipment_num
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,

Line 12606: mtl_system_items when Checking for Item details. */

12602: /* Bug # 2286618, Autocreate was not grouping Req. lines when two req.
12603: with the same line details was entered. This happened when they Entered
12604: a One Time Item in the lines block. We were not considering that the Item
12605: can be NULL when grouping shipment line. Used outer join on
12606: mtl_system_items when Checking for Item details. */
12607:
12608: l_progress:='190';
12609: SELECT PLI.shipment_num
12610: INTO x_po_shipment_num

Line 12614: MTL_SYSTEM_ITEMS MSI ,

12610: INTO x_po_shipment_num
12611: FROM PO_LINES_INTERFACE PLI,
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,

Line 13181: FROM mtl_system_items msi

13177:
13178: if x_item_id is not null then
13179: SELECT msi.revision_qty_control_code
13180: INTO x_item_rev_control
13181: FROM mtl_system_items msi
13182: WHERE msi.inventory_item_id = x_item_id
13183: AND msi.organization_id = x_inv_org_id;
13184: end if;
13185:

Line 13240: l_ship_org_id_line mtl_system_items.organization_id%type;

13236: l_progress varchar2(3) := '000'; --< Bug 3210331 >
13237: l_api_name VARCHAR2(30) := 'create_price_break'; --< Bug 3210331, 3336920 >
13238: unexpected_create_pb_err EXCEPTION;
13239:
13240: l_ship_org_id_line mtl_system_items.organization_id%type;
13241: l_ship_org_code varchar2(3);
13242: l_ship_org_name varchar2(60);
13243:
13244: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --