[Home] [Help]
242: * are changed.
243: */
244:
245: l_wip_entity_id NUMBER;
246: l_wip_op_seq_num rcv_transactions.WIP_OPERATION_SEQ_NUM%type;
247: l_osp_dept_code VARCHAR2(10);
248: l_bom_resource_id NUMBER;
249: l_bom_resource_code VARCHAR2(20);
250: l_wip_entity_name wip_osp_jobs_val_v.wip_entity_name%TYPE;
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
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
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
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
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
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
695: --8533306
696: , rt.po_distribution_id
697: --Bug 8632067
698: , rt.transaction_id
699: FROM rcv_transactions rt
700: , rcv_lots_supply rls -- Reverted to original code as part of Bug#4516067
701: -- , rcv_lot_transactions rls -- Replaced rcv_lot_transactions by mtl_transaction_lot_numbers to fetch the LOT details as part of Bug# 4186856
702: -- Added rt2 as part of Bug# 4186856
703: -- rt2, mtln commented for Bug#4516067 to revert the changes done for Bug#4186856
701: -- , rcv_lot_transactions rls -- Replaced rcv_lot_transactions by mtl_transaction_lot_numbers to fetch the LOT details as part of Bug# 4186856
702: -- Added rt2 as part of Bug# 4186856
703: -- rt2, mtln commented for Bug#4516067 to revert the changes done for Bug#4186856
704: /* , (select transaction_id
705: * from rcv_transactions rt_deliver
706: * where rt_deliver.group_id = p_transaction_id
707: * and rt_deliver.transaction_type = 'DELIVER') rt2
708: * , mtl_transaction_lot_numbers mtln -- Added as part of Bug# 4186856
709: */
902: --8533306
903: , rt.po_distribution_id
904: --Bug 8632067
905: ,rt.transaction_id
906: FROM rcv_transactions rt
907: , mtl_transaction_lot_numbers mtln
908: , rcv_shipment_lines rsl
909: , po_lines_trx_v pol -- CLM project, bug 9403291
910: -- , po_distributions_all pod --Commented as part of Bug# 3586116
1085: --Bug 8648128
1086: , rt.po_distribution_id
1087: --Bug 8632067
1088: , rt.transaction_id
1089: FROM rcv_transactions rt
1090: , mtl_transaction_lot_numbers mtln
1091: , rcv_shipment_lines rsl
1092: , po_lines_trx_v pol -- CLM project, bug 9403291
1093: -- , po_distributions_all pod --Commented as part of Bug# 3586116
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
1696: /*Bug# 3238878
1697: To get Org Type for Patchset J and above */
1698: CURSOR rt_get_org_cur IS
1699: SELECT organization_id
1700: FROM rcv_transactions rt
1701: WHERE rt.group_id = p_transaction_id
1702: and ( (p_label_type_info.business_flow_code = 1 AND rt.transaction_type = 'RECEIVE')
1703: OR (p_label_type_info.business_flow_code = 2 AND rt.transaction_type in ('ACCEPT', 'REJECT') )
1704: OR (p_label_type_info.business_flow_code = 3 AND rt.transaction_type = 'DELIVER')
1914: /* For Bug 4916450 defined the cursor pod_project_task */
1915: CURSOR pod_project_task IS
1916: SELECT DISTINCT pod.project_id, pod.task_id
1917: FROM po_distributions_all pod,
1918: rcv_transactions rt
1919: WHERE pod.po_header_id = rt.po_header_id
1920: AND pod.po_line_id = rt.po_line_id
1921: AND pod.line_location_id = rt.po_line_location_id
1922: AND pod.po_distribution_id = nvl(rt.po_distribution_id, pod.po_distribution_id)
3434: IF p_label_type_info.business_flow_code IN (1,3) THEN
3435:
3436: SELECT uom_code
3437: INTO l_uom
3438: FROM rcv_transactions
3439: WHERE transaction_id = l_rcv_transaction_id;
3440:
3441: END IF;
3442:
3443: IF p_label_type_info.business_flow_code = 2 THEN
3444:
3445: SELECT muom.uom_code
3446: INTO l_uom
3447: FROM rcv_transactions rt,
3448: mtl_units_of_measure_vl muom
3449: WHERE rt.unit_of_measure = muom.unit_of_measure
3450: AND rt.transaction_id = l_rcv_transaction_id;
3451: