APPS.INVIDIT3 dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 330: FROM mtl_material_transactions_temp

326: WHERE master_organization_id = p_master_org))
327: AND ROWNUM = 1;
328:
329: SELECT count(1) INTO material_org_count
330: FROM mtl_material_transactions_temp
331: WHERE inventory_item_id = p_item_id
332: AND organization_id = p_org_id
333: AND rownum = 1;
334:

Line 336: --rows exist in mtl_material_transactions_temp

332: AND organization_id = p_org_id
333: AND rownum = 1;
334:
335: --bug 7355994(7356679,7356680): setting lot-serial flag to be 1 in case
336: --rows exist in mtl_material_transactions_temp
337: IF (material_org_count = 1) THEN
338: material_org_count_ls := 1;
339: END IF;
340:

Line 376: FROM mtl_material_transactions_temp

372: END IF;
373:
374: IF (material_org_count <> 1) THEN
375: SELECT COUNT(1) INTO material_master_count
376: FROM mtl_material_transactions_temp
377: WHERE inventory_item_id = p_item_id
378: AND (organization_id IN (SELECT organization_id
379: FROM mtl_parameters
380: WHERE master_organization_id = p_master_org))

Line 384: --case rows exist in mtl_material_transactions_temp

380: WHERE master_organization_id = p_master_org))
381: AND rownum = 1;
382:
383: --bug 7355994(7356679,7356680): setting lot-serial flag to be 1 in
384: --case rows exist in mtl_material_transactions_temp
385: IF(material_master_count = 1) THEN
386: material_master_count_ls := 1;
387: END IF;
388:

Line 1205: mtl_material_transactions_temp

1201: -- X_cost_txn will have either 0 or 1 or 2
1202: /* Bug 14334921 START
1203: We need to perform the below checks on the tables
1204: mtl_onhand_quantities_detail
1205: mtl_material_transactions_temp
1206: mtl_material_transactions
1207: while updating the Costing_enabled_flag or inventory_asset_flag.
1208: In addition,
1209: 1) If org controlled, then we check for current org

Line 1256: from mtl_material_transactions_temp

1252: -- if (cost_moq <> 1 and cost_moq2 <> 1) then
1253: if (cost_moq <> 1) then
1254: select count(1)
1255: into cost_tmp
1256: from mtl_material_transactions_temp
1257: where inventory_item_id = p_item_id
1258: and organization_id = p_org_id
1259: /* Bug 14334921 (select organization_id
1260: from mtl_parameters

Line 1271: from mtl_material_transactions_temp

1267: if (cost_moq <> 1 AND cost_tmp <> 1 AND cost_moq2 <> 2) then
1268:
1269: select count(1) + Count(2)
1270: into cost_tmp2
1271: from mtl_material_transactions_temp
1272: where inventory_item_id = p_item_id
1273: and organization_id in
1274: (select organization_id
1275: from mtl_parameters