eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LABEL_PVT1 dependencies on RCV_TRANSACTIONS

Line 239: l_wip_op_seq_num rcv_transactions.WIP_OPERATION_SEQ_NUM%type;

235: * are changed.
236: */
237:
238: l_wip_entity_id NUMBER;
239: l_wip_op_seq_num rcv_transactions.WIP_OPERATION_SEQ_NUM%type;
240: l_osp_dept_code VARCHAR2(10);
241: l_bom_resource_id NUMBER;
242: l_bom_resource_code VARCHAR2(20);
243: l_wip_entity_name wip_osp_jobs_val_v.wip_entity_name%TYPE;

Line 360: FROM rcv_transactions_interface rti

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

Line 442: FROM rcv_transactions_interface rti

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

Line 512: FROM rcv_transactions_interface rti

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

Line 543: FROM rcv_transactions_interface rti

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

Line 557: FROM rcv_transactions_interface

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

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

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

Line 686: FROM rcv_transactions rt

682: , rt.BOM_RESOURCE_ID wip_bom_resource_id
683: , wlpn.lpn_context
684: , wlpn.lpn_id
685: , rt.routing_header_id routing_header_id --bug 4916450
686: FROM rcv_transactions rt
687: , rcv_lots_supply rls -- Reverted to original code as part of Bug#4516067
688: -- , rcv_lot_transactions rls -- Replaced rcv_lot_transactions by mtl_transaction_lot_numbers to fetch the LOT details as part of Bug# 4186856
689: -- Added rt2 as part of Bug# 4186856
690: -- rt2, mtln commented for Bug#4516067 to revert the changes done for Bug#4186856

Line 692: * from rcv_transactions rt_deliver

688: -- , rcv_lot_transactions rls -- Replaced rcv_lot_transactions by mtl_transaction_lot_numbers to fetch the LOT details as part of Bug# 4186856
689: -- Added rt2 as part of Bug# 4186856
690: -- rt2, mtln commented for Bug#4516067 to revert the changes done for Bug#4186856
691: /* , (select transaction_id
692: * from rcv_transactions rt_deliver
693: * where rt_deliver.group_id = p_transaction_id
694: * and rt_deliver.transaction_type = 'DELIVER') rt2
695: * , mtl_transaction_lot_numbers mtln -- Added as part of Bug# 4186856
696: */

Line 881: FROM rcv_transactions rt

877: , rt.BOM_RESOURCE_ID
878: , wlpn.lpn_context
879: , wlpn.lpn_id
880: , rt.routing_header_id routing_header_id --bug 4916450
881: FROM rcv_transactions rt
882: , mtl_transaction_lot_numbers mtln
883: , rcv_shipment_lines rsl
884: , po_lines_all pol
885: -- , po_distributions_all pod --Commented as part of Bug# 3586116

Line 1052: FROM rcv_transactions rt

1048: , rt.BOM_RESOURCE_ID
1049: , wlpn.lpn_context
1050: , wlpn.lpn_id
1051: , rt.routing_header_id --bug 4916450
1052: FROM rcv_transactions rt
1053: , mtl_transaction_lot_numbers mtln
1054: , rcv_shipment_lines rsl
1055: , po_lines_all pol
1056: -- , po_distributions_all pod --Commented as part of Bug# 3586116

Line 1644: FROM rcv_transactions_interface rti

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

Line 1652: FROM rcv_transactions rt

1648: /*Bug# 3238878
1649: To get Org Type for Patchset J and above */
1650: CURSOR rt_get_org_cur IS
1651: SELECT organization_id
1652: FROM rcv_transactions rt
1653: WHERE rt.group_id = p_transaction_id
1654: and ( (p_label_type_info.business_flow_code = 1 AND rt.transaction_type = 'RECEIVE')
1655: OR (p_label_type_info.business_flow_code = 2 AND rt.transaction_type in ('ACCEPT', 'REJECT') )
1656: OR (p_label_type_info.business_flow_code = 3 AND rt.transaction_type = 'DELIVER')

Line 1869: rcv_transactions rt

1865: /* For Bug 4916450 defined the cursor pod_project_task */
1866: CURSOR pod_project_task IS
1867: SELECT DISTINCT pod.project_id, pod.task_id
1868: FROM po_distributions_all pod,
1869: rcv_transactions rt
1870: WHERE pod.po_header_id = rt.po_header_id
1871: AND pod.po_line_id = rt.po_line_id
1872: AND pod.line_location_id = rt.po_line_location_id
1873: AND pod.po_distribution_id = nvl(rt.po_distribution_id, pod.po_distribution_id)