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 3048: x_ship_to_loc_org_id mtl_system_items.organization_id%TYPE;

3044: x_description ap_tax_codes.description%type;
3045: x_allow_tax_code_override_flag gl_tax_option_accounts.allow_tax_code_override_flag%type;
3046: x_tax_name po_lines.tax_name%type;
3047: x_ship_to_location_id number:= 0;
3048: x_ship_to_loc_org_id mtl_system_items.organization_id%TYPE;
3049: x_ship_org_code varchar2(3);
3050:
3051: /** **/
3052: /** tpoon 9/29/2002 **/

Line 3071: x_inv_org_id mtl_system_items.organization_id%TYPE;

3067: x_retvar BOOLEAN;
3068: ic_item_mst_rec IC_ITEM_MST%ROWTYPE;
3069: ic_item_cpg_rec IC_ITEM_CPG%ROWTYPE;
3070: x_order_opm_um ic_item_mst.item_um%type := NULL;
3071: x_inv_org_id mtl_system_items.organization_id%TYPE;
3072: **/
3073: l_api_name CONSTANT VARCHAR2(30) := 'create_line';
3074: d_mod CONSTANT VARCHAR2(255) := g_log_head||l_api_name;
3075: -- end of 2219743

Line 3400: FROM mtl_system_items

3396: BEGIN
3397: l_progress := '080';
3398: SELECT segment1
3399: INTO x_item_number
3400: FROM mtl_system_items
3401: WHERE
3402: inventory_item_id = interface.item_id
3403: AND organization_id = x_inv_org_id;
3404:

Line 3587: FROM mtl_system_items msi

3583: INTO item.invoice_close_tolerance,
3584: item.receive_close_tolerance,
3585: item.inspection_required_flag,
3586: item.receipt_required_flag
3587: FROM mtl_system_items msi
3588: WHERE msi.inventory_item_id = interface.item_id
3589: AND msi.organization_id = interface.destination_organization_id;
3590:
3591: exception

Line 3637: FROM mtl_system_items msi

3633: item.invoice_close_tolerance,
3634: item.receive_close_tolerance,
3635: item.secondary_uom_code, --
3636: item.grade_control_flag --
3637: FROM mtl_system_items msi
3638: WHERE msi.inventory_item_id = interface.item_id
3639: AND msi.organization_id = params.inventory_organization_id;
3640:
3641: exception

Line 3994: from mtl_system_items

3990: begin
3991: l_progress:='270';
3992: select un_number_id,hazard_class_id
3993: into x_un_number_id,x_hazard_class_id
3994: from mtl_system_items
3995: where inventory_item_id = interface.item_id
3996: and organization_id =params.inventory_organization_id;
3997: exception
3998: when no_data_found then

Line 4693: FROM mtl_system_items msi

4689: INTO item.invoice_close_tolerance,
4690: item.receive_close_tolerance,
4691: item.receipt_required_flag,
4692: item.inspection_required_flag
4693: FROM mtl_system_items msi
4694: WHERE msi.inventory_item_id = interface.item_id
4695: AND msi.organization_id = interface.destination_organization_id;
4696:
4697: exception

Line 4728: FROM mtl_system_items msi

4724: item.receive_close_tolerance,
4725: item.receipt_required_flag,
4726: item.inspection_required_flag,
4727: item.secondary_uom_code --
4728: FROM mtl_system_items msi
4729: WHERE msi.inventory_item_id = interface.item_id
4730: AND msi.organization_id = params.inventory_organization_id;
4731: exception
4732: when no_data_found then

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

5687: x_price number; /* used to get release price from PA */
5688: x_price_break_type varchar2(25) := '';
5689: x_doctype varchar2(25) := ''; /* used for call to update close state */
5690: x_return_code varchar2(25) := ''; /* used for call to update close state */
5691: x_item_org_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5692: x_ship_to_org_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5693: x_return_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5694:
5695: /* For converting qty if line_type is not quantity based */

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

5688: x_price_break_type varchar2(25) := '';
5689: x_doctype varchar2(25) := ''; /* used for call to update close state */
5690: x_return_code varchar2(25) := ''; /* used for call to update close state */
5691: x_item_org_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5692: x_ship_to_org_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5693: x_return_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5694:
5695: /* For converting qty if line_type is not quantity based */
5696: x_order_type_lookup_code varchar2(25) :='';

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

5689: x_doctype varchar2(25) := ''; /* used for call to update close state */
5690: x_return_code varchar2(25) := ''; /* used for call to update close state */
5691: x_item_org_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5692: x_ship_to_org_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5693: x_return_taxable_flag mtl_system_items.taxable_flag%type := NULL;
5694:
5695: /* For converting qty if line_type is not quantity based */
5696: x_order_type_lookup_code varchar2(25) :='';
5697: x_quantity number :=0;

Line 10629: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE;

10625:
10626: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
10627:
10628: --
10629: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE;
10630: l_line_grade MTL_GRADES.GRADE_CODE%TYPE;
10631: --
10632:
10633: l_max_iface_line_num NUMBER; --

Line 11475: FROM mtl_system_items

11471:
11472: BEGIN
11473: SELECT grade_control_flag
11474: INTO l_grade_control_flag
11475: FROM mtl_system_items
11476: WHERE inventory_item_id = x_item_id
11477: and organization_id = params.inventory_organization_id;
11478: EXCEPTION
11479: WHEN OTHERS THEN

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

12997: /* Bug # 2224446, Autocreate was not grouping Req. lines when two req.
12998: with the same line details was entered. This happened when they don't
12999: Enter a Item in the lines block. We were not considering that the Item
13000: can be NULL when grouping shipment line. Used outer join on
13001: mtl_system_items when Checking for Item details. */
13002:
13003: --
13004: --As per the HLD.
13005: --Only Requisition grouping will be available for the new Service line types.

Line 13024: mtl_system_items msi,

13020: INTO x_receipt_required_flag
13021: FROM po_lines_interface pli,
13022: po_headers_interface phi,
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 --

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

13066: /*
13067: ** See if a record that has just been inserted into the
13068: ** interface table matches the shipment you are trying to create.
13069: */
13070: /* Bug # 2224446, Added outer join on mtl_system_items */
13071: /* Bug: 2348161.Changed the below SQL and removed the reference to the tables
13072: HZ_LOCATIONS and HR_LOCATIONS and also the corresponding where
13073: clause. Instead added a subquery to check for the location_id
13074: to improve the performance

Line 13087: MTL_SYSTEM_ITEMS MSI ,

13083: ,x_req_line_to_check
13084: FROM PO_LINES_INTERFACE PLI,
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,

Line 13208: MTL_SYSTEM_ITEMS MSI ,

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

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

13324: /* Bug # 2286618, Autocreate was not grouping Req. lines when two req.
13325: with the same line details was entered. This happened when they Entered
13326: a One Time Item in the lines block. We were not considering that the Item
13327: can be NULL when grouping shipment line. Used outer join on
13328: mtl_system_items when Checking for Item details. */
13329:
13330: l_progress:='190';
13331: SELECT PLI.shipment_num
13332: INTO x_po_shipment_num

Line 13336: MTL_SYSTEM_ITEMS MSI ,

13332: INTO x_po_shipment_num
13333: FROM PO_LINES_INTERFACE PLI,
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,

Line 14083: FROM mtl_system_items msi

14079:
14080: if x_item_id is not null then
14081: SELECT msi.revision_qty_control_code
14082: INTO x_item_rev_control
14083: FROM mtl_system_items msi
14084: WHERE msi.inventory_item_id = x_item_id
14085: AND msi.organization_id = x_inv_org_id;
14086: end if;
14087:

Line 14142: l_ship_org_id_line mtl_system_items.organization_id%type;

14138: l_progress varchar2(3) := '000'; --< Bug 3210331 >
14139: l_api_name VARCHAR2(30) := 'create_price_break'; --< Bug 3210331, 3336920 >
14140: unexpected_create_pb_err EXCEPTION;
14141:
14142: l_ship_org_id_line mtl_system_items.organization_id%type;
14143: l_ship_org_code varchar2(3);
14144: l_ship_org_name varchar2(60);
14145:
14146: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --