[Home] [Help]
86: mti.reason_id,
87: mti.transaction_reference
88: from mtl_transactions_interface mti,
89: wip_entities we,
90: mtl_system_items msi
91: where mti.transaction_header_id = p_txnHeaderID
92: and mti.transaction_source_type_id = 5
93: and mti.transaction_action_id in (wip_constants.cplassy_action,
94: wip_constants.retassy_action,
644: into l_locatorCntlCode,
645: l_projRefEnabled
646: from mtl_parameters p,
647: mtl_secondary_inventories s,
648: mtl_system_items i
649: where i.inventory_item_id = pt_rec.inventory_item_id
650: and i.organization_id = pt_rec.organization_id
651: and s.secondary_inventory_name = pt_rec.subinventory_code
652: and s.organization_id = pt_rec.organization_id
1056: WIP_CONSTANTS.RETCOMP_ACTION,
1057: WIP_CONSTANTS.ISSNEGC_ACTION,
1058: WIP_CONSTANTS.RETNEGC_ACTION)
1059: and not exists (select 'X'
1060: from mtl_system_items msi
1061: where msi.organization_id = mti.organization_id
1062: and msi.inventory_item_id = mti.inventory_item_id
1063: and msi.mtl_transactions_enabled_flag = 'Y'
1064: and msi.bom_enabled_flag = 'Y'
1166: and transaction_action_id in (WIP_CONSTANTS.CPLASSY_ACTION,
1167: WIP_CONSTANTS.RETASSY_ACTION)
1168: and wip_entity_type in (1,5)
1169: and exists(select 'X'
1170: from mtl_system_items msi
1171: where msi.organization_id = mti.organization_id
1172: and msi.inventory_item_id = mti.inventory_item_id
1173: and msi.revision_qty_control_code = 2);
1174:
1192: and transaction_action_id in (WIP_CONSTANTS.CPLASSY_ACTION,
1193: WIP_CONSTANTS.RETASSY_ACTION)
1194: and wip_entity_type = 2
1195: and exists(select 'X'
1196: from mtl_system_items msi
1197: where msi.organization_id = mti.organization_id
1198: and msi.inventory_item_id = mti.inventory_item_id
1199: and msi.revision_qty_control_code = 2);
1200:
1218: WIP_CONSTANTS.RETASSY_ACTION,
1219: WIP_CONSTANTS.SCRASSY_ACTION)
1220: and wip_entity_type = 4
1221: and exists(select 'X'
1222: from mtl_system_items msi
1223: where msi.organization_id = mti.organization_id
1224: and msi.inventory_item_id = mti.inventory_item_id
1225: and msi.revision_qty_control_code = 2);
1226:
1271: and transaction_action_id in (WIP_CONSTANTS.CPLASSY_ACTION,
1272: WIP_CONSTANTS.RETASSY_ACTION,
1273: WIP_CONSTANTS.SCRASSY_ACTION)
1274: and exists (select 'X'
1275: from mtl_system_items msi
1276: where msi.organization_id = mti.organization_id
1277: and msi.inventory_item_id = mti.inventory_item_id
1278: and msi.revision_qty_control_code = 2 )
1279: and not exists (select 'X'
1315: WIP_CONSTANTS.ISSNEGC_ACTION,
1316: WIP_CONSTANTS.RETNEGC_ACTION)
1317: and revision is null
1318: and exists (select 'X'
1319: from mtl_system_items msi
1320: where msi.organization_id = mti.organization_id
1321: and msi.inventory_item_id = mti.inventory_item_id
1322: and msi.revision_qty_control_code = 2);
1323:
1350: WIP_CONSTANTS.ISSNEGC_ACTION,
1351: WIP_CONSTANTS.RETNEGC_ACTION)
1352: and ( ( revision is not null
1353: and ( ( exists(select 'item under rev ctl'
1354: from mtl_system_items msi
1355: where msi.organization_id = mti.organization_id
1356: and msi.inventory_item_id = mti.inventory_item_id
1357: and msi.revision_qty_control_code = 2)
1358: and not exists(select 'rev effective and not an open/hold eco'
1370: and MIR.inventory_item_id = mti.inventory_item_id
1371: and MIR.revision = mti.revision
1372: and MIR.effectivity_date <= sysdate))
1373: or (exists (select 'item not under rev ctl'
1374: from mtl_system_items msi
1375: where msi.organization_id = mti.organization_id
1376: and msi.inventory_item_id = mti.inventory_item_id
1377: and msi.revision_qty_control_code = 1))))
1378: or ( revision is null
1376: and msi.inventory_item_id = mti.inventory_item_id
1377: and msi.revision_qty_control_code = 1))))
1378: or ( revision is null
1379: and ( exists(select 'item is under rev control'
1380: from mtl_system_items msi
1381: where msi.organization_id = mti.organization_id
1382: and msi.inventory_item_id = mti.inventory_item_id
1383: and msi.revision_qty_control_code = 2)
1384: and not exists (select 'any effective rev'
1502: and transaction_action_id <> WIP_CONSTANTS.SCRASSY_ACTION
1503: and ( ( l_poExpToAssetTnsf = 2
1504: and not exists(select 'X'
1505: from mtl_secondary_inventories sub,
1506: mtl_system_items msi
1507: where msi.organization_id = mti.organization_id
1508: and msi.inventory_item_id = msi.inventory_item_id
1509: and sub.organization_id = mti.organization_id
1510: and sub.secondary_inventory_name = mti.subinventory_code
1904:
1905: if ( l_primaryCostMethod in (2, 5, 6) ) then
1906: select primary_uom_code
1907: into l_priUOM
1908: from mtl_system_items
1909: where organization_id = nonCfm_rec.organization_id
1910: and inventory_item_id = nonCfm_rec.inventory_item_id;
1911:
1912: l_priQty := inv_convert.inv_um_convert(
2400: mp.stock_locator_control_code)
2401: into l_locctrl
2402: from mtl_parameters mp,
2403: mtl_secondary_inventories sub,
2404: mtl_system_items it
2405: where it.inventory_item_id = l_itemIDTbl(i)
2406: and sub.secondary_inventory_name = l_subCodeTbl(i)
2407: and mp.organization_id = l_orgIDTbl(i)
2408: and it.organization_id = sub.organization_id
2482: where transaction_header_id = p_txnHeaderID
2483: and process_flag = 1
2484: and transaction_source_type_id = 5
2485: and not exists (select 'X'
2486: from mtl_system_items msi
2487: where msi.inventory_item_id = mti.inventory_item_id
2488: and msi.organization_id = mti.organization_id
2489: and msi.inventory_item_flag = 'Y');
2490:
2688: l_itemIDTbl,
2689: l_orgIDTbl,
2690: l_itemNameTbl
2691: from mtl_transactions_interface mti,
2692: mtl_system_items_kfv msik
2693: where mti.transaction_header_id = p_txnHeaderID
2694: and mti.transaction_batch_id = p_txnBatchID
2695: and mti.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
2696: wip_constants.issnegc_action, wip_constants.retnegc_action)