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.WMS_SHIPPING_LOVS dependencies on STANDARD

Line 123: AND oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')

119: , wsh_delivery_details wdd
120: , wsh_delivery_assignments_v wda
121: WHERE oel.ship_from_org_id = p_organization_id
122: AND oel.header_id = p_source_header_id
123: AND oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')
124: AND wda.parent_delivery_detail_id = p_parent_delivery_detail_id
125: AND wdd.delivery_detail_id = wda.delivery_detail_id
126: AND oel.line_id = wdd.source_line_id
127: AND msik.inventory_item_id = oel.inventory_item_id

Line 156: (SELECT utt_emp.standard_operation_id standard_operation_id,

152: FROM oe_order_headers_all oeh ,
153: mtl_sales_orders mso ,
154: mtl_material_transactions_temp mmtt,
155: -- inlined wms_person_resource_utt_v
156: (SELECT utt_emp.standard_operation_id standard_operation_id,
157: utt_emp.person_id emp_id ,
158: utt_eqp.inventory_item_id eqp_id
159: FROM
160: (SELECT x_utt_res1.standard_operation_id standard_operation_id,

Line 160: (SELECT x_utt_res1.standard_operation_id standard_operation_id,

156: (SELECT utt_emp.standard_operation_id standard_operation_id,
157: utt_emp.person_id emp_id ,
158: utt_eqp.inventory_item_id eqp_id
159: FROM
160: (SELECT x_utt_res1.standard_operation_id standard_operation_id,
161: x_emp_r.person_id
162: FROM bom_std_op_resources x_utt_res1,
163: bom_resources r1 ,
164: bom_resource_employees x_emp_r

Line 169: (SELECT x_utt_res2.standard_operation_id standard_operation_id,

165: WHERE x_utt_res1.resource_id = r1.resource_id
166: AND r1.resource_type = 2
167: AND x_utt_res1.resource_id = x_emp_r.resource_id
168: ) utt_emp ,
169: (SELECT x_utt_res2.standard_operation_id standard_operation_id,
170: x_eqp_r.inventory_item_id
171: FROM bom_std_op_resources x_utt_res2,
172: bom_resources r2 ,
173: bom_resource_equipments x_eqp_r

Line 178: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)

174: WHERE x_utt_res2.resource_id = r2.resource_id
175: AND r2.resource_type = 1
176: AND x_utt_res2.resource_id = x_eqp_r.resource_id
177: ) utt_eqp
178: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)
179: ) v ,
180: mtl_secondary_inventories sub
181: WHERE mmtt.organization_id = p_organization_id
182: AND oeh.order_number LIKE (p_order_number)

Line 187: AND mmtt.standard_operation_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

183: AND mmtt.transaction_source_id = mso.sales_order_id
184: AND mso.segment1 = oeh.order_number
185: AND oeh.order_number NOT IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.list_order_numbers) )
186: AND v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
187: AND mmtt.standard_operation_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
188: AND mmtt.subinventory_code = NVL(p_zone, mmtt.subinventory_code)
189: AND NVL(v.eqp_id, -999) = NVL(p_equipment_id, NVL(v.eqp_id, -999))
190: AND mmtt.subinventory_code = sub.secondary_inventory_name
191: AND mmtt.organization_id = sub.organization_id

Line 215: (SELECT utt_emp.standard_operation_id standard_operation_id,

211: OPEN x_pickslip_lov FOR
212: SELECT DISTINCT mmtt.pick_slip_number
213: FROM mtl_material_transactions_temp mmtt,
214: -- inlined wms_person_resource_utt_v
215: (SELECT utt_emp.standard_operation_id standard_operation_id,
216: utt_emp.person_id emp_id ,
217: utt_eqp.inventory_item_id eqp_id
218: FROM
219: (SELECT x_utt_res1.standard_operation_id standard_operation_id,

Line 219: (SELECT x_utt_res1.standard_operation_id standard_operation_id,

215: (SELECT utt_emp.standard_operation_id standard_operation_id,
216: utt_emp.person_id emp_id ,
217: utt_eqp.inventory_item_id eqp_id
218: FROM
219: (SELECT x_utt_res1.standard_operation_id standard_operation_id,
220: x_emp_r.person_id
221: FROM bom_std_op_resources x_utt_res1,
222: bom_resources r1 ,
223: bom_resource_employees x_emp_r

Line 228: (SELECT x_utt_res2.standard_operation_id standard_operation_id,

224: WHERE x_utt_res1.resource_id = r1.resource_id
225: AND r1.resource_type = 2
226: AND x_utt_res1.resource_id = x_emp_r.resource_id
227: ) utt_emp ,
228: (SELECT x_utt_res2.standard_operation_id standard_operation_id,
229: x_eqp_r.inventory_item_id
230: FROM bom_std_op_resources x_utt_res2,
231: bom_resources r2 ,
232: bom_resource_equipments x_eqp_r

Line 237: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)

233: WHERE x_utt_res2.resource_id = r2.resource_id
234: AND r2.resource_type = 1
235: AND x_utt_res2.resource_id = x_eqp_r.resource_id
236: ) utt_eqp
237: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)
238: ) v ,
239: mtl_secondary_inventories sub
240: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
241: AND mmtt.organization_id = p_organization_id

Line 242: AND mmtt.standard_operation_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

238: ) v ,
239: mtl_secondary_inventories sub
240: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
241: AND mmtt.organization_id = p_organization_id
242: AND mmtt.standard_operation_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
243: AND mmtt.subinventory_code = NVL(p_zone, mmtt.subinventory_code)
244: AND NVL(v.eqp_id, -999) = NVL(p_equipment_id, NVL(v.eqp_id, -999))
245: AND mmtt.subinventory_code = sub.secondary_inventory_name
246: AND mmtt.organization_id = sub.organization_id