DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on MTL_MATERIAL_TRANSACTIONS

Line 114: , p_input_param IN mtl_material_transactions_temp%ROWTYPE

110: , x_msg_data OUT NOCOPY VARCHAR2
111: , x_return_status OUT NOCOPY VARCHAR2
112: , p_label_type_info IN inv_label.label_type_rec
113: , p_transaction_id IN NUMBER
114: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
115: , p_transaction_identifier IN NUMBER
116: ) IS
117: -- Fix for 4888701: Included the Precsion and Scale for the variable quatity.
118: --l_quantity NUMBER := 0;

Line 122: l_uom mtl_material_transactions.transaction_uom%TYPE;

118: --l_quantity NUMBER := 0;
119: l_quantity NUMBER(38,5) := 0;
120: -- End of fix for 4888701
121:
122: l_uom mtl_material_transactions.transaction_uom%TYPE;
123: l_revision mtl_material_transactions.revision%TYPE;
124: l_inventory_item_id NUMBER;
125: l_item_description VARCHAR2(240) := NULL;
126: l_organization_id NUMBER;

Line 123: l_revision mtl_material_transactions.revision%TYPE;

119: l_quantity NUMBER(38,5) := 0;
120: -- End of fix for 4888701
121:
122: l_uom mtl_material_transactions.transaction_uom%TYPE;
123: l_revision mtl_material_transactions.revision%TYPE;
124: l_inventory_item_id NUMBER;
125: l_item_description VARCHAR2(240) := NULL;
126: l_organization_id NUMBER;
127: l_lot_number VARCHAR2(240);

Line 715: FROM mtl_material_transactions mmt1

711: , wip_entities we -- Added for Bug#4516067
712: , wip_discrete_jobs wdj -- Added for Bug#4516067
713: , wms_license_plate_numbers wlpn -- Bug 3836623
714: , (SELECT cost_group_id, rcv_transaction_id
715: FROM mtl_material_transactions mmt1
716: WHERE mmt1.rcv_transaction_id = p_transaction_id
717: AND nvl(mmt1.logical_transaction, -999) <> 1) mmt -- Modified for bug# 5515979
718: --, mtl_material_transactions mmt -- Added for the Bug # 4770558
719: WHERE rls.transaction_id(+) = rt.transaction_id -- Reverted to original code as part of Bug#4516067

Line 718: --, mtl_material_transactions mmt -- Added for the Bug # 4770558

714: , (SELECT cost_group_id, rcv_transaction_id
715: FROM mtl_material_transactions mmt1
716: WHERE mmt1.rcv_transaction_id = p_transaction_id
717: AND nvl(mmt1.logical_transaction, -999) <> 1) mmt -- Modified for bug# 5515979
718: --, mtl_material_transactions mmt -- Added for the Bug # 4770558
719: WHERE rls.transaction_id(+) = rt.transaction_id -- Reverted to original code as part of Bug#4516067
720: --mtln.product_transaction_id(+) = rt.transaction_id -- Commented as part of Bug#4186856
721: /* Reverted to original code as part of Bug#4516067
722: * mtln.product_code = 'RCV' -- Added as part of Bug#4186856

Line 901: FROM mtl_material_transactions mmt1

897: , wip_entities we
898: , wip_discrete_jobs wdj
899: , wms_license_plate_numbers wlpn -- Bug 3836623
900: , (SELECT cost_group_id, rcv_transaction_id
901: FROM mtl_material_transactions mmt1
902: WHERE mmt1.rcv_transaction_id = p_transaction_id
903: AND nvl(mmt1.logical_transaction, -999) <> 1) mmt -- Modified for bug# 5515979
904: --, mtl_material_transactions mmt -- Added for the Bug # 4770558
905: WHERE mtln.product_transaction_id(+) = rt.transaction_id

Line 904: --, mtl_material_transactions mmt -- Added for the Bug # 4770558

900: , (SELECT cost_group_id, rcv_transaction_id
901: FROM mtl_material_transactions mmt1
902: WHERE mmt1.rcv_transaction_id = p_transaction_id
903: AND nvl(mmt1.logical_transaction, -999) <> 1) mmt -- Modified for bug# 5515979
904: --, mtl_material_transactions mmt -- Added for the Bug # 4770558
905: WHERE mtln.product_transaction_id(+) = rt.transaction_id
906: AND mtln.product_code(+) = 'RCV'
907: AND pol.po_line_id(+) = rt.po_line_id
908: AND pha.po_header_id(+) = rt.po_header_id

Line 1272: FROM mtl_material_transactions_temp mmtt

1268: , mtlt.origination_type
1269: , mtlt.hold_date
1270: , mtlt.expiration_action_code
1271: , mtlt.supplier_lot_number -- invconv end
1272: FROM mtl_material_transactions_temp mmtt
1273: ,mtl_transaction_lots_temp mtlt
1274: ,wip_entities we -- Fix For Bug: 4907062
1275: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1276: AND mmtt.transaction_temp_id = p_transaction_id

Line 1303: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1299: , mmtt.locator_id
1300: , mmtt.transfer_to_location
1301: , mmtt.secondary_uom_code -- added for invconv
1302: , ABS(NVL(mtlt.secondary_quantity, mmtt.secondary_transaction_quantity)) -- added for invconv
1303: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1304: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1305: AND mmtt.transaction_temp_id = p_transaction_id
1306: AND mmtt.content_lpn_id IS NULL
1307: UNION ALL

Line 1324: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt

1320: , mmtt.locator_id
1321: , mmtt.transfer_to_location
1322: , wlc.secondary_uom_code -- added for invconv
1323: , wlc.secondary_quantity -- added for invconv
1324: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1325: WHERE mmtt.transaction_temp_id = p_transaction_id
1326: AND mmtt.content_lpn_id IS NOT NULL
1327: AND mmtt.content_lpn_id = wlc.parent_lpn_id;
1328:

Line 1350: FROM mtl_material_transactions_temp mmtt

1346: , mmtt.SECONDARY_UOM_CODE secondary_uom -- fabdi bug 4387144
1347: , mmtt.revision revision
1348: , mmtt.transfer_subinventory
1349: , mmtt.transfer_to_location
1350: FROM mtl_material_transactions_temp mmtt
1351: , mtl_transaction_lots_temp mtlt
1352: , mtl_material_transactions_temp mmtt_orgin
1353: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1354: AND mmtt.transaction_header_id = mmtt_orgin.transaction_header_id

Line 1352: , mtl_material_transactions_temp mmtt_orgin

1348: , mmtt.transfer_subinventory
1349: , mmtt.transfer_to_location
1350: FROM mtl_material_transactions_temp mmtt
1351: , mtl_transaction_lots_temp mtlt
1352: , mtl_material_transactions_temp mmtt_orgin
1353: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1354: AND mmtt.transaction_header_id = mmtt_orgin.transaction_header_id
1355: AND mmtt.transaction_temp_id <> mmtt_orgin.transaction_temp_id
1356: AND mmtt_orgin.content_lpn_id IS NOT NULL

Line 1372: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1368: , mmtt.SECONDARY_UOM_CODE secondary_uom -- fabdi bug 4387144
1369: , mmtt.revision revision
1370: , mmtt.transfer_subinventory
1371: , mmtt.transfer_to_location
1372: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1373: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1374: AND mmtt.content_lpn_id IS NULL
1375: AND mmtt.transaction_temp_id = p_transaction_id;
1376:

Line 1398: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1394: , mmtt.locator_id
1395: , mmtt.transfer_to_location
1396: , ABS(NVL(mtlt.secondary_quantity, mmtt.secondary_transaction_quantity)) secondary_quantity -- invconv changes
1397: , mmtt.secondary_uom_code -- invconv changes
1398: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1399: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1400: AND mmtt.transfer_lpn_id IS NULL
1401: AND mmtt.content_lpn_id IS NULL
1402: AND mmtt.transaction_temp_id = p_transaction_id

Line 1420: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt

1416: , mmtt.locator_id
1417: , mmtt.transfer_to_location
1418: , wlc.secondary_quantity -- added for invconv
1419: , wlc.secondary_uom_code -- added for invconv
1420: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1421: WHERE mmtt.transaction_temp_id = p_transaction_id
1422: AND mmtt.content_lpn_id = wlc.parent_lpn_id
1423: UNION ALL
1424: -- This part of the cursor is for 2 cases. Items unpacked from an LPN and packed into another LPN AND

Line 1441: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt

1437: , mmtt.locator_id
1438: , mmtt.transfer_to_location
1439: , wlc.secondary_quantity -- added for invconv
1440: , wlc.secondary_uom_code -- added for invconv
1441: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1442: WHERE mmtt.transaction_temp_id = p_transaction_id
1443: AND mmtt.transfer_lpn_id = wlc.parent_lpn_id
1444: UNION ALL
1445: -- This part of the cursor is for all cases except loose items being packed into an existing/new LPN.

Line 1461: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt

1457: , mmtt.locator_id
1458: , mmtt.transfer_to_location
1459: , wlc.secondary_quantity -- added for invconv
1460: , wlc.secondary_uom_code -- added for invconv
1461: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1462: WHERE mmtt.transaction_temp_id = p_transaction_id
1463: AND mmtt.lpn_id = wlc.parent_lpn_id;
1464:
1465: -- Packaging/Cartonization Cursors

Line 1488: FROM mtl_material_transactions_temp mmtt

1484: , mmtt.inventory_item_id
1485: , mmtt.revision
1486: , mtlt.lot_number
1487: , SUM(mmtt.primary_quantity) quantity
1488: FROM mtl_material_transactions_temp mmtt
1489: , mtl_transaction_lots_temp mtlt
1490: WHERE mmtt.cartonization_id = p_transaction_id
1491: AND mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1492: GROUP BY mmtt.organization_id

Line 1565: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1561: , mmtt.transaction_uom
1562: , mmtt.revision
1563: , mmtt.subinventory_code
1564: , mmtt.locator_id
1565: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1566: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1567: AND mmtt.transaction_temp_id = p_transaction_id;
1568: */
1569: -- For business_flow_code of Manufacturing Cross-Dock

Line 1582: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1578: , mmtt.transaction_uom
1579: , mmtt.revision
1580: , mmtt.subinventory_code
1581: , mmtt.locator_id
1582: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1583: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1584: AND mmtt.transaction_temp_id = p_transaction_id;
1585:
1586: -- For business flow code of 33, the MMTT, MTI or MOL id is passed

Line 1602: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1598: , mmtt.transaction_uom uom
1599: , mmtt.revision revision
1600: , mmtt.subinventory_code
1601: , mmtt.locator_id
1602: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1603: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
1604: AND mmtt.transaction_temp_id = p_transaction_id;
1605:
1606: CURSOR flow_material_curs_mti IS

Line 1938: mtl_material_transactions_temp mmtt

1934: ppf.full_name requestor
1935: FROM mtl_cycle_count_headers mcch,
1936: mtl_cycle_count_entries mcce,
1937: per_people_f ppf,
1938: mtl_material_transactions_temp mmtt
1939: WHERE mmtt.transaction_temp_id= p_transaction_id
1940: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
1941: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
1942: AND ppf.person_id(+) = mcce.counted_by_employee_id_current;

Line 2800: from mtl_material_transactions_temp

2796: (/*8,*/ 9, 11, 12, 14, 19, 18, 22, 23, 27, 28, 29, 34)--Bug 5928736 - Removed business flow 7
2797: OR (p_label_type_info.business_flow_code = 8 AND p_transaction_identifier = 5)
2798: THEN
2799: select transaction_type_id into l_transaction_type
2800: from mtl_material_transactions_temp
2801: where transaction_temp_id = p_transaction_id; --bug 6646793
2802:
2803: OPEN mmtt_material_cur;
2804: FETCH mmtt_material_cur INTO l_inventory_item_id

Line 2832: from mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt

2828: ELSE
2829: --bug 6646793
2830: if (l_transaction_type = 82 and p_label_type_info.business_flow_code = 12)then
2831: select nvl (mmtt.transaction_quantity,mtlt.transaction_quantity) into l_mmtt_quantity
2832: from mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt
2833: where mmtt.transaction_temp_id = p_transaction_id
2834: and mtlt.transaction_temp_id = mmtt.transaction_temp_id;
2835:
2836: SELECT Nvl(Sum(primary_transaction_quantity),0) INTO l_moqd_quantity

Line 2837: FROM mtl_onhand_quantities_detail moqd , mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt

2833: where mmtt.transaction_temp_id = p_transaction_id
2834: and mtlt.transaction_temp_id = mmtt.transaction_temp_id;
2835:
2836: SELECT Nvl(Sum(primary_transaction_quantity),0) INTO l_moqd_quantity
2837: FROM mtl_onhand_quantities_detail moqd , mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt
2838: WHERE mmtt.transaction_temp_id = p_transaction_id
2839: and mtlt.transaction_temp_id = mmtt.transaction_temp_id
2840: and moqd.lot_number = mtlt.lot_number
2841: and nvl(mmtt.lpn_id , -999) = nvl(moqd.lpn_id , -999)

Line 5579: , p_input_param IN mtl_material_transactions_temp%ROWTYPE

5575: , x_msg_data OUT NOCOPY VARCHAR2
5576: , x_return_status OUT NOCOPY VARCHAR2
5577: , p_label_type_info IN inv_label.label_type_rec
5578: , p_transaction_id IN NUMBER
5579: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
5580: , p_transaction_identifier IN NUMBER
5581: ) IS
5582: l_variable_data_tbl inv_label.label_tbl_type;
5583: BEGIN