[Home] [Help]
356: , WOJV.DESCRIPTION
357: , RTI.WIP_OPERATION_SEQ_NUM
358: , rti.DEPARTMENT_CODE
359: , rti.BOM_RESOURCE_ID
360: FROM rcv_transactions_interface rti
361: , wms_lpn_contents wlc
362: , po_lines_all pol
363: , po_headers_all pha
364: , rcv_shipment_headers rsh
438: , WOJV.DESCRIPTION
439: , RTI.WIP_OPERATION_SEQ_NUM
440: , rti.DEPARTMENT_CODE
441: , rti.BOM_RESOURCE_ID
442: FROM rcv_transactions_interface rti
443: , wms_lpn_contents wlc
444: , po_lines_all pol
445: , po_headers_all pha
446: , rcv_shipment_headers rsh
508: , WOJV.DESCRIPTION
509: , RTI.WIP_OPERATION_SEQ_NUM
510: , rti.DEPARTMENT_CODE
511: , rti.BOM_RESOURCE_ID
512: FROM rcv_transactions_interface rti
513: , wip_osp_jobs_val_v wojv
514: , mtl_transaction_lots_temp mtlt
515: , /***************************************/
516: (SELECT rti.GROUP_ID
539: , rrh.routing_name routing_name
540: , rti.item_description item_description
541: , rti.subinventory subinventory
542: , rti.locator_id locator_id
543: FROM rcv_transactions_interface rti
544: , po_lines_all pol
545: , po_headers_all pha
546: , rcv_shipment_headers rsh
547: , po_line_locations_all pll
553: , hr_employees hre
554: , rcv_routing_headers rrh
555: , wip_osp_jobs_val_v wojv
556: WHERE rti.GROUP_ID IN (SELECT GROUP_ID
557: FROM rcv_transactions_interface
558: WHERE interface_transaction_id =
559: p_transaction_id)
560: AND pol.po_line_id(+) = rti.po_line_id
561: AND pha.po_header_id(+) = rti.po_header_id
610: , rti.DEPARTMENT_CODE
611: , rti.BOM_RESOURCE_ID;
612:
613: /* 3069426 - Patchset J project - Label printing enhancements -
614: * Use one cursor that queries RCV_TRANSACTIONS_INTERFACE and RCV_LOTS_INTERFACE tables for
615: * Item, Lot, Quantity information
616: */
617:
618: -- MOAC: Replaced the po_line_locations
1640:
1641: -- To get org type.
1642: CURSOR rti_get_org_cur IS
1643: SELECT to_organization_id
1644: FROM rcv_transactions_interface rti
1645: WHERE rti.interface_transaction_id = p_transaction_id;
1646:
1647:
1648: /*Bug# 3238878