APPS.WIP_PICKING_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 535: from MTL_TXN_REQUEST_LINES mtrl

531: begin
532: begin
533: select distinct mtrl.transaction_type_id
534: into l_txn_type_id
535: from MTL_TXN_REQUEST_LINES mtrl
536: where
537: mtrl.TXN_SOURCE_ID = p_wip_entity_id and
538: mtrl.TXN_SOURCE_LINE_ID = p_operation_seq_num and
539: mtrl.organization_id = p_organization_id and

Line 569: from MTL_TXN_REQUEST_LINES mtrl

565: begin
566: if (l_txn_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE) then
567: select sum(nvl(mtrl.quantity,0) - nvl(mtrl.quantity_delivered,0))
568: into l_quantity_allocated
569: from MTL_TXN_REQUEST_LINES mtrl
570: where
571: mtrl.TXN_SOURCE_ID = p_wip_entity_id and
572: mtrl.TXN_SOURCE_LINE_ID = p_operation_seq_num and
573: ( p_repetitive_schedule_id is null or

Line 584: from MTL_TXN_REQUEST_LINES mtrl

580: mtrl.TXN_SOURCE_LINE_ID, mtrl.INVENTORY_ITEM_ID;
581: else
582: select sum(nvl(mtrl.quantity,0))
583: into l_mtrl_quantity
584: from MTL_TXN_REQUEST_LINES mtrl
585: where
586: mtrl.TXN_SOURCE_ID = p_wip_entity_id and
587: mtrl.TXN_SOURCE_LINE_ID = p_operation_seq_num and
588: ( p_repetitive_schedule_id is null or

Line 610: from MTL_TXN_REQUEST_LINES mtrl

606: into l_dummy
607: from dual
608: where exists
609: ( select 1
610: from MTL_TXN_REQUEST_LINES mtrl
611: where
612: mtrl.backorder_delivery_detail_id = p_wip_entity_id and
613: mtrl.TXN_SOURCE_LINE_ID is null and
614: ( p_repetitive_schedule_id is null or