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.INV_LABEL_PVT10 dependencies on MTL_PARAMETERS

Line 407: MTL_PARAMETERS kanban_sorg,

403: kanban.kanban_card_number
404: FROM MTL_KANBAN_CARDS kanban,
405: MTL_ITEM_LOCATIONS_KFV kanban_loc,
406: MTL_ITEM_LOCATIONS_KFV kanban_sloc,
407: MTL_PARAMETERS kanban_sorg,
408: MTL_PARAMETERS kanban_org,
409: PO_VENDORS pv
410: WHERE kanban.kanban_card_id = p_kanban_card_id
411: AND kanban.locator_id = kanban_loc.inventory_location_id(+)

Line 408: MTL_PARAMETERS kanban_org,

404: FROM MTL_KANBAN_CARDS kanban,
405: MTL_ITEM_LOCATIONS_KFV kanban_loc,
406: MTL_ITEM_LOCATIONS_KFV kanban_sloc,
407: MTL_PARAMETERS kanban_sorg,
408: MTL_PARAMETERS kanban_org,
409: PO_VENDORS pv
410: WHERE kanban.kanban_card_id = p_kanban_card_id
411: AND kanban.locator_id = kanban_loc.inventory_location_id(+)
412: AND kanban.source_locator_id = kanban_sloc.inventory_location_id(+)

Line 741: mtl_parameters lpn_mp,

737: FROM wms_license_plate_numbers lpn,
738: wms_license_plate_numbers lpn_pLpn,
739: mtl_system_items_kfv lpn_msik1,
740: mtl_system_items_kfv lpn_msik2,
741: mtl_parameters lpn_mp,
742: wms_lpn_contents lpn_wlc
743: WHERE lpn.lpn_id = p_lpn_id
744: AND lpn.parent_lpn_id = lpn_pLpn.lpn_id(+)
745: AND lpn_wlc.parent_lpn_id(+) = p_lpn_id

Line 837: l_organization_code mtl_parameters.organization_code%TYPE;

833: l_ship_from_org_id oe_order_headers_all.ship_from_org_id%TYPE;
834: l_ship_to_org_id oe_order_headers_all.ship_to_org_id%TYPE;
835: l_invoice_to_org_id oe_order_headers_all.invoice_to_org_id%TYPE;
836: l_deliver_to_org_id oe_order_headers_all.deliver_to_org_id%TYPE;
837: l_organization_code mtl_parameters.organization_code%TYPE;
838: l_location_id hz_locations.location_id%TYPE;
839: l_location_name hz_cust_site_uses_all.location%TYPE;
840: l_organization_name org_organization_definitions.organization_name%TYPE;
841: l_customer_number hz_cust_accounts.account_number%TYPE;

Line 848: l_ship_from_organization_code mtl_parameters.organization_code%TYPE;

844: l_ship_from_location_id hz_locations.location_id%TYPE;
845: l_ship_to_location_id hz_locations.location_id%TYPE;
846: l_invoice_to_location_id hz_locations.location_id%TYPE;
847: l_deliver_to_location_id hz_locations.location_id%TYPE;
848: l_ship_from_organization_code mtl_parameters.organization_code%TYPE;
849: l_ship_to_organization_code mtl_parameters.organization_code%TYPE;
850: l_sold_from_organization_code mtl_parameters.organization_code%TYPE;
851: l_sold_to_organization_code mtl_parameters.organization_code%TYPE;
852: l_invoice_to_organization_code mtl_parameters.organization_code%TYPE;

Line 849: l_ship_to_organization_code mtl_parameters.organization_code%TYPE;

845: l_ship_to_location_id hz_locations.location_id%TYPE;
846: l_invoice_to_location_id hz_locations.location_id%TYPE;
847: l_deliver_to_location_id hz_locations.location_id%TYPE;
848: l_ship_from_organization_code mtl_parameters.organization_code%TYPE;
849: l_ship_to_organization_code mtl_parameters.organization_code%TYPE;
850: l_sold_from_organization_code mtl_parameters.organization_code%TYPE;
851: l_sold_to_organization_code mtl_parameters.organization_code%TYPE;
852: l_invoice_to_organization_code mtl_parameters.organization_code%TYPE;
853: l_deliver_to_organization_code mtl_parameters.organization_code%TYPE;

Line 850: l_sold_from_organization_code mtl_parameters.organization_code%TYPE;

846: l_invoice_to_location_id hz_locations.location_id%TYPE;
847: l_deliver_to_location_id hz_locations.location_id%TYPE;
848: l_ship_from_organization_code mtl_parameters.organization_code%TYPE;
849: l_ship_to_organization_code mtl_parameters.organization_code%TYPE;
850: l_sold_from_organization_code mtl_parameters.organization_code%TYPE;
851: l_sold_to_organization_code mtl_parameters.organization_code%TYPE;
852: l_invoice_to_organization_code mtl_parameters.organization_code%TYPE;
853: l_deliver_to_organization_code mtl_parameters.organization_code%TYPE;
854: l_address5 hz_locations.address4%TYPE;

Line 851: l_sold_to_organization_code mtl_parameters.organization_code%TYPE;

847: l_deliver_to_location_id hz_locations.location_id%TYPE;
848: l_ship_from_organization_code mtl_parameters.organization_code%TYPE;
849: l_ship_to_organization_code mtl_parameters.organization_code%TYPE;
850: l_sold_from_organization_code mtl_parameters.organization_code%TYPE;
851: l_sold_to_organization_code mtl_parameters.organization_code%TYPE;
852: l_invoice_to_organization_code mtl_parameters.organization_code%TYPE;
853: l_deliver_to_organization_code mtl_parameters.organization_code%TYPE;
854: l_address5 hz_locations.address4%TYPE;
855: l_header_id oe_order_headers_all.header_id%TYPE := p_header_id;

Line 852: l_invoice_to_organization_code mtl_parameters.organization_code%TYPE;

848: l_ship_from_organization_code mtl_parameters.organization_code%TYPE;
849: l_ship_to_organization_code mtl_parameters.organization_code%TYPE;
850: l_sold_from_organization_code mtl_parameters.organization_code%TYPE;
851: l_sold_to_organization_code mtl_parameters.organization_code%TYPE;
852: l_invoice_to_organization_code mtl_parameters.organization_code%TYPE;
853: l_deliver_to_organization_code mtl_parameters.organization_code%TYPE;
854: l_address5 hz_locations.address4%TYPE;
855: l_header_id oe_order_headers_all.header_id%TYPE := p_header_id;
856:

Line 853: l_deliver_to_organization_code mtl_parameters.organization_code%TYPE;

849: l_ship_to_organization_code mtl_parameters.organization_code%TYPE;
850: l_sold_from_organization_code mtl_parameters.organization_code%TYPE;
851: l_sold_to_organization_code mtl_parameters.organization_code%TYPE;
852: l_invoice_to_organization_code mtl_parameters.organization_code%TYPE;
853: l_deliver_to_organization_code mtl_parameters.organization_code%TYPE;
854: l_address5 hz_locations.address4%TYPE;
855: l_header_id oe_order_headers_all.header_id%TYPE := p_header_id;
856:
857:

Line 919: , MTL_PARAMETERS ohead_mp

915: ohead.ship_from_org_id,
916: ohead.invoice_to_org_id,
917: ohead.deliver_to_org_id
918: FROM OE_ORDER_HEADERS_ALL ohead
919: , MTL_PARAMETERS ohead_mp
920: --
921: -- Modification Start for Bug # - 4418524
922: --
923: -- As part of TCA related changes ra_customers, ra_contacts views are

Line 1178: MTL_PARAMETERS ship_from_org

1174: --ORG_FREIGHT_VL ofv,
1175: RA_SALESREPS ras,
1176: OE_SETS,
1177: AR_LOOKUPS,
1178: MTL_PARAMETERS ship_from_org
1179: WHERE oline.line_id = p_line_id
1180: AND oline.sold_to_org_id = oline_rc.customer_id(+)
1181: AND oline.deliver_to_contact_id = dcontact.contact_id(+)
1182: AND oline.ship_to_contact_id = shiptoc.contact_id(+)

Line 1281: mtl_parameters mp,

1277: mp.organization_code
1278: -- hou.name organization_name,
1279: -- hou.organization_id
1280: FROM hr_organization_units hou,
1281: mtl_parameters mp,
1282: hr_organization_information hoi1
1283: WHERE hou.ORGANIZATION_ID = mp.ORGANIZATION_ID
1284: AND hou.ORGANIZATION_ID = hoi1.ORGANIZATION_id
1285: AND hoi1.ORG_INFORMATION1= 'INV'

Line 1692: MTL_PARAMETERS ship_from_org

1688: --ORG_FREIGHT_VL ofv,
1689: RA_SALESREPS ras,
1690: OE_SETS,
1691: AR_LOOKUPS,
1692: MTL_PARAMETERS ship_from_org
1693: WHERE oline.line_id = p_line_id
1694: AND oline.deliver_to_contact_id = dcontact.contact_id(+)
1695: AND oline.intmed_ship_to_contact_id = isc.contact_id(+)
1696: AND oline.salesrep_id = ras.salesrep_id(+)