APPS.WMS_LPN_LOVS dependencies on MTL_TXN_REQUEST_LINES

Line 2647: -- inspection_status in mtl_txn_request_lines could have values {null,1,2,3}

2643: )
2644: IS
2645: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2646: BEGIN
2647: -- inspection_status in mtl_txn_request_lines could have values {null,1,2,3}
2648: -- mapping to {Inspection not needed, Inspection needed, Accepted, Rejected }
2649: -- We want those that are pending inspection
2650:
2651: OPEN x_lpn_lov FOR

Line 2670: mtl_txn_request_lines b,

2666: a.content_volume_uom_code,
2667: NVL(a.content_volume, 0),
2668: nvl(rec_count.lpn_content_count, 0)
2669: FROM wms_license_plate_numbers a,
2670: mtl_txn_request_lines b,
2671: (SELECT count(*) lpn_content_count,grouped_contents.lpn_id
2672: FROM (SELECT mtrl.lpn_id lpn_id, -- Need extra grouping to group
2673: mtrl.inventory_item_id item_id,
2674: mtrl.revision revision

Line 2678: FROM wms_license_plate_numbers wlpn, mtl_txn_request_lines mtrl

2674: mtrl.revision revision
2675: --BUG 3358288: Use MOL to calculate the count instead of
2676: --using WLC because there may be items there does not
2677: --require inspection
2678: FROM wms_license_plate_numbers wlpn, mtl_txn_request_lines mtrl
2679: WHERE wlpn.license_plate_number LIKE (p_lpn)
2680: AND mtrl.lpn_id = wlpn.lpn_id
2681: AND mtrl.inspection_status = 1
2682: AND mtrl.wms_process_flag = 1

Line 2692: -- Check to make sure that the processing for mtl_txn_request_lines is completed or not.

2688: and a.lpn_id = b.lpn_id
2689: and a.lpn_context in (3,5)
2690: and b.inspection_status = 1
2691: -- Bug 2377796
2692: -- Check to make sure that the processing for mtl_txn_request_lines is completed or not.
2693: and b.wms_process_flag = 1
2694: AND b.line_status = 7
2695: AND (b.quantity-Nvl(b.quantity_delivered,0))>0
2696: and b.organization_id = p_organization_id

Line 3218: from mtl_txn_request_lines mtrl

3214: AND wlpn.organization_id = p_org_id
3215: and wlpn.lpn_context = 3
3216: AND exists (
3217: select lpn_id
3218: from mtl_txn_request_lines mtrl
3219: where mtrl.organization_id = p_org_id
3220: and mtrl.project_id = p_project_id
3221: and mtrl.lpn_id = wlpn.lpn_id
3222: and nvl(task_id,-9999) = nvl(p_task_id,-9999)

Line 3323: from mtl_txn_request_lines mtrl

3319: AND organization_id = p_org_id
3320: AND lpn_context = 3
3321: and exists (
3322: select mtrl.lpn_id
3323: from mtl_txn_request_lines mtrl
3324: where mtrl.organization_id = p_org_id
3325: and mtrl.project_id is null
3326: and mtrl.lpn_id = wlpn.lpn_id
3327: and nvl(mtrl.task_id,-9999) = nvl(p_task_id,-9999)