DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on MTL_TXN_REQUEST_HEADERS

Line 2009: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,

2005: mtrl.secondary_uom_code AS secondary_uom_code,
2006: mtrl.project_id AS project_id,
2007: mtrl.task_id AS task_id,
2008: mtrl.lpn_id AS lpn_id
2009: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,
2010: wms_license_plate_numbers wlpn
2011: WHERE mtrl.header_id = mtrh.header_id
2012: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
2013: AND mtrl.organization_id = l_organization_id

Line 2323: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,

2319: mtrl.secondary_uom_code AS secondary_uom_code,
2320: mtrl.project_id AS project_id,
2321: mtrl.task_id AS task_id,
2322: mtrl.lpn_id AS lpn_id
2323: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,
2324: wms_license_plate_numbers wlpn
2325: WHERE mtrl.header_id = mtrh.header_id
2326: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
2327: AND mtrl.organization_id = l_organization_id

Line 6660: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,

6656: p_wip_entity_id NUMBER,
6657: p_operation_seq_num NUMBER,
6658: p_repetitive_schedule_id NUMBER) IS
6659: SELECT mtrl.line_id
6660: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,
6661: wms_license_plate_numbers wlpn
6662: WHERE mtrl.header_id = mtrh.header_id
6663: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
6664: AND mtrl.organization_id = l_organization_id