APPS.INV_LABEL_PVT1 dependencies on RCV_TRANSACTIONS_INTERFACE

Line 367: FROM rcv_transactions_interface rti

363: , WOJV.DESCRIPTION
364: , RTI.WIP_OPERATION_SEQ_NUM
365: , rti.DEPARTMENT_CODE
366: , rti.BOM_RESOURCE_ID
367: FROM rcv_transactions_interface rti
368: , wms_lpn_contents wlc
369: , po_lines_trx_v pol -- CLM project, bug 9403291
370: , po_headers_trx_v pha -- CLM project, bug 9403291
371: , rcv_shipment_headers rsh

Line 449: FROM rcv_transactions_interface rti

445: , WOJV.DESCRIPTION
446: , RTI.WIP_OPERATION_SEQ_NUM
447: , rti.DEPARTMENT_CODE
448: , rti.BOM_RESOURCE_ID
449: FROM rcv_transactions_interface rti
450: , wms_lpn_contents wlc
451: , po_lines_trx_v pol -- CLM project, bug 9403291
452: , po_headers_trx_v pha -- CLM projet, bug 9403291
453: , rcv_shipment_headers rsh

Line 519: FROM rcv_transactions_interface rti

515: , WOJV.DESCRIPTION
516: , RTI.WIP_OPERATION_SEQ_NUM
517: , rti.DEPARTMENT_CODE
518: , rti.BOM_RESOURCE_ID
519: FROM rcv_transactions_interface rti
520: , wip_osp_jobs_val_v wojv
521: , mtl_transaction_lots_temp mtlt
522: , /***************************************/
523: (SELECT rti.GROUP_ID

Line 550: FROM rcv_transactions_interface rti

546: , rrh.routing_name routing_name
547: , rti.item_description item_description
548: , rti.subinventory subinventory
549: , rti.locator_id locator_id
550: FROM rcv_transactions_interface rti
551: , po_lines_trx_v pol -- CLM project, bug 9403291
552: , po_headers_trx_v pha -- CLM project, bug 9403291
553: , rcv_shipment_headers rsh
554: , po_line_locations_trx_v pll -- CLM project, bug 9403291

Line 564: FROM rcv_transactions_interface

560: , hr_employees hre
561: , rcv_routing_headers rrh
562: , wip_osp_jobs_val_v wojv
563: WHERE rti.GROUP_ID IN (SELECT GROUP_ID
564: FROM rcv_transactions_interface
565: WHERE interface_transaction_id =
566: p_transaction_id)
567: AND pol.po_line_id(+) = rti.po_line_id
568: AND pha.po_header_id(+) = rti.po_header_id

Line 621: * Use one cursor that queries RCV_TRANSACTIONS_INTERFACE and RCV_LOTS_INTERFACE tables for

617: , rti.DEPARTMENT_CODE
618: , rti.BOM_RESOURCE_ID;
619:
620: /* 3069426 - Patchset J project - Label printing enhancements -
621: * Use one cursor that queries RCV_TRANSACTIONS_INTERFACE and RCV_LOTS_INTERFACE tables for
622: * Item, Lot, Quantity information
623: */
624:
625: -- MOAC: Replaced the po_line_locations

Line 1692: FROM rcv_transactions_interface rti

1688:
1689: -- To get org type.
1690: CURSOR rti_get_org_cur IS
1691: SELECT to_organization_id
1692: FROM rcv_transactions_interface rti
1693: WHERE rti.interface_transaction_id = p_transaction_id;
1694:
1695:
1696: /*Bug# 3238878