[Home] [Help]
93: mti.reason_id,
94: mti.transaction_reference
95: from mtl_transactions_interface mti,
96: wip_entities we,
97: mtl_system_items msi
98: where mti.transaction_header_id = p_txnHeaderID
99: and mti.transaction_source_type_id = 5
100: and mti.transaction_action_id in (wip_constants.cplassy_action,
101: wip_constants.retassy_action,
651: into l_locatorCntlCode,
652: l_projRefEnabled
653: from mtl_parameters p,
654: mtl_secondary_inventories s,
655: mtl_system_items i
656: where i.inventory_item_id = pt_rec.inventory_item_id
657: and i.organization_id = pt_rec.organization_id
658: and s.secondary_inventory_name = pt_rec.subinventory_code
659: and s.organization_id = pt_rec.organization_id
1071: WIP_CONSTANTS.RETCOMP_ACTION,
1072: WIP_CONSTANTS.ISSNEGC_ACTION,
1073: WIP_CONSTANTS.RETNEGC_ACTION)
1074: and not exists (select 'X'
1075: from mtl_system_items msi
1076: where msi.organization_id = mti.organization_id
1077: and msi.inventory_item_id = mti.inventory_item_id
1078: and msi.mtl_transactions_enabled_flag = 'Y'
1079: and msi.bom_enabled_flag = 'Y'
1212: and transaction_action_id in (WIP_CONSTANTS.CPLASSY_ACTION,
1213: WIP_CONSTANTS.RETASSY_ACTION)
1214: and wip_entity_type in (1,5)
1215: and exists(select 'X'
1216: from mtl_system_items msi
1217: where msi.organization_id = mti.organization_id
1218: and msi.inventory_item_id = mti.inventory_item_id
1219: and msi.revision_qty_control_code = 2);
1220:
1238: and transaction_action_id in (WIP_CONSTANTS.CPLASSY_ACTION,
1239: WIP_CONSTANTS.RETASSY_ACTION)
1240: and wip_entity_type = 2
1241: and exists(select 'X'
1242: from mtl_system_items msi
1243: where msi.organization_id = mti.organization_id
1244: and msi.inventory_item_id = mti.inventory_item_id
1245: and msi.revision_qty_control_code = 2);
1246:
1264: WIP_CONSTANTS.RETASSY_ACTION,
1265: WIP_CONSTANTS.SCRASSY_ACTION)
1266: and wip_entity_type = 4
1267: and exists(select 'X'
1268: from mtl_system_items msi
1269: where msi.organization_id = mti.organization_id
1270: and msi.inventory_item_id = mti.inventory_item_id
1271: and msi.revision_qty_control_code = 2);
1272:
1317: and transaction_action_id in (WIP_CONSTANTS.CPLASSY_ACTION,
1318: WIP_CONSTANTS.RETASSY_ACTION,
1319: WIP_CONSTANTS.SCRASSY_ACTION)
1320: and exists (select 'X'
1321: from mtl_system_items msi
1322: where msi.organization_id = mti.organization_id
1323: and msi.inventory_item_id = mti.inventory_item_id
1324: and msi.revision_qty_control_code = 2 )
1325: and not exists (select 'X'
1361: WIP_CONSTANTS.ISSNEGC_ACTION,
1362: WIP_CONSTANTS.RETNEGC_ACTION)
1363: and revision is null
1364: and exists (select 'X'
1365: from mtl_system_items msi
1366: where msi.organization_id = mti.organization_id
1367: and msi.inventory_item_id = mti.inventory_item_id
1368: and msi.revision_qty_control_code = 2);
1369:
1396: WIP_CONSTANTS.ISSNEGC_ACTION,
1397: WIP_CONSTANTS.RETNEGC_ACTION)
1398: and ( ( revision is not null
1399: and ( ( exists(select 'item under rev ctl'
1400: from mtl_system_items msi
1401: where msi.organization_id = mti.organization_id
1402: and msi.inventory_item_id = mti.inventory_item_id
1403: and msi.revision_qty_control_code = 2)
1404: and not exists(select 'rev effective and not an open/hold eco'
1416: and MIR.inventory_item_id = mti.inventory_item_id
1417: and MIR.revision = mti.revision
1418: and MIR.effectivity_date <= sysdate))
1419: or (exists (select 'item not under rev ctl'
1420: from mtl_system_items msi
1421: where msi.organization_id = mti.organization_id
1422: and msi.inventory_item_id = mti.inventory_item_id
1423: and msi.revision_qty_control_code = 1))))
1424: or ( revision is null
1422: and msi.inventory_item_id = mti.inventory_item_id
1423: and msi.revision_qty_control_code = 1))))
1424: or ( revision is null
1425: and ( exists(select 'item is under rev control'
1426: from mtl_system_items msi
1427: where msi.organization_id = mti.organization_id
1428: and msi.inventory_item_id = mti.inventory_item_id
1429: and msi.revision_qty_control_code = 2)
1430: and not exists (select 'any effective rev'
1548: and transaction_action_id <> WIP_CONSTANTS.SCRASSY_ACTION
1549: and ( ( l_poExpToAssetTnsf = 2
1550: and not exists(select 'X'
1551: from mtl_secondary_inventories sub,
1552: mtl_system_items msi
1553: where msi.organization_id = mti.organization_id
1554: and msi.inventory_item_id = msi.inventory_item_id
1555: and sub.organization_id = mti.organization_id
1556: and sub.secondary_inventory_name = mti.subinventory_code
1954:
1955: if ( l_primaryCostMethod in (2, 5, 6) ) then
1956: select primary_uom_code
1957: into l_priUOM
1958: from mtl_system_items
1959: where organization_id = nonCfm_rec.organization_id
1960: and inventory_item_id = nonCfm_rec.inventory_item_id;
1961:
1962: l_priQty := inv_convert.inv_um_convert(
2449: mp.stock_locator_control_code)
2450: into l_locctrl
2451: from mtl_parameters mp,
2452: mtl_secondary_inventories sub,
2453: mtl_system_items it
2454: where it.inventory_item_id = l_itemIDTbl(i)
2455: and sub.secondary_inventory_name = l_subCodeTbl(i)
2456: and mp.organization_id = l_orgIDTbl(i)
2457: and it.organization_id = sub.organization_id
2531: where transaction_header_id = p_txnHeaderID
2532: and process_flag = 1
2533: and transaction_source_type_id = 5
2534: and not exists (select 'X'
2535: from mtl_system_items msi
2536: where msi.inventory_item_id = mti.inventory_item_id
2537: and msi.organization_id = mti.organization_id
2538: and msi.inventory_item_flag = 'Y');
2539:
2737: l_itemIDTbl,
2738: l_orgIDTbl,
2739: l_itemNameTbl
2740: from mtl_transactions_interface mti,
2741: mtl_system_items_kfv msik
2742: where mti.transaction_header_id = p_txnHeaderID
2743: and mti.transaction_batch_id = p_txnBatchID
2744: and mti.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
2745: wip_constants.issnegc_action, wip_constants.retnegc_action)