DBA Data[Home] [Help]

APPS.INVTVTUS dependencies on MTL_MATERIAL_TRANSACTIONS

Line 12: sdate mtl_material_transactions.transaction_date%TYPE,

8: invid mtl_system_items.inventory_item_id%TYPE,
9: rev mtl_item_revisions.revision%TYPE,
10: uom mtl_system_items.primary_uom_code%TYPE,
11: puom mtl_system_items.primary_uom_code%TYPE,
12: sdate mtl_material_transactions.transaction_date%TYPE,
13: edate mtl_material_transactions.transaction_date%TYPE,
14: cg_id mtl_secondary_inventories.default_cost_group_id%TYPE)
15: is
16: cratio number := 1;

Line 13: edate mtl_material_transactions.transaction_date%TYPE,

9: rev mtl_item_revisions.revision%TYPE,
10: uom mtl_system_items.primary_uom_code%TYPE,
11: puom mtl_system_items.primary_uom_code%TYPE,
12: sdate mtl_material_transactions.transaction_date%TYPE,
13: edate mtl_material_transactions.transaction_date%TYPE,
14: cg_id mtl_secondary_inventories.default_cost_group_id%TYPE)
15: is
16: cratio number := 1;
17: prc number := 1;

Line 64: from mtl_material_transactions mmt,

60: round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
61: sum(1),
62: cratio*sum(abs(mmt.primary_quantity)),
63: round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
64: from mtl_material_transactions mmt,
65: mfg_lookups ml,
66: mtl_txn_source_types mtst,
67: mtl_transaction_types mtt
68: where mmt.inventory_item_id = invid

Line 174: from mtl_material_transactions mmt

170: round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
171: sum(1),
172: cratio*sum(abs(mmt.primary_quantity)),
173: round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
174: from mtl_material_transactions mmt
175: where mmt.inventory_item_id = invid
176: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
177: and mmt.organization_id = orgid
178: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)

Line 205: from mtl_material_transactions mmt

201: round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
202: sum(1),
203: cratio*sum(abs(mmt.primary_quantity)),
204: round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
205: from mtl_material_transactions mmt
206: where mmt.inventory_item_id = invid
207: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
208: and mmt.organization_id = orgid
209: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)

Line 263: from mtl_material_transactions mmt

259: round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
260: sum(1),
261: cratio*sum(abs(mmt.primary_quantity)),
262: round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
263: from mtl_material_transactions mmt
264: where mmt.inventory_item_id = invid
265: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
266: and mmt.organization_id = orgid
267: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)

Line 313: from mtl_material_transactions mmt

309: nvl(cratio*sum(mmt.primary_quantity),0),
310: round(nvl(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),0),prc),
311: nvl(sum(1),0),
312: 1
313: from mtl_material_transactions mmt
314: where mmt.inventory_item_id = invid
315: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
316: and mmt.organization_id = orgid
317: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)

Line 338: from mtl_material_transactions mmt

334: nvl(abs(cratio*sum(mmt.primary_quantity)),0),
335: round(nvl(abs(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity)),0),prc),
336: nvl(sum(1),0),
337: 2
338: from mtl_material_transactions mmt
339: where mmt.inventory_item_id = invid
340: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
341: and mmt.organization_id = orgid
342: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)

Line 380: sdate mtl_material_transactions.transaction_date%TYPE,

376: sub mtl_secondary_inventories.secondary_inventory_name%TYPE,
377: locid mtl_item_locations.inventory_location_id%TYPE,
378: catsetid mtl_category_sets.category_set_id%TYPE,
379: catid mtl_categories.category_id%TYPE,
380: sdate mtl_material_transactions.transaction_date%TYPE,
381: edate mtl_material_transactions.transaction_date%TYPE,
382: cg_id mtl_secondary_inventories.default_cost_group_id%TYPE)
383: is
384: msgbuf varchar2(200);

Line 381: edate mtl_material_transactions.transaction_date%TYPE,

377: locid mtl_item_locations.inventory_location_id%TYPE,
378: catsetid mtl_category_sets.category_set_id%TYPE,
379: catid mtl_categories.category_id%TYPE,
380: sdate mtl_material_transactions.transaction_date%TYPE,
381: edate mtl_material_transactions.transaction_date%TYPE,
382: cg_id mtl_secondary_inventories.default_cost_group_id%TYPE)
383: is
384: msgbuf varchar2(200);
385: prc number := 1;

Line 433: from mtl_material_transactions mmt,

429: round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
430: sum(1),
431: sum(abs(mmt.primary_quantity)),
432: round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
433: from mtl_material_transactions mmt,
434: mtl_txn_source_types mtst,
435: mfg_lookups ml,
436: mtl_transaction_types mtt
437: where mmt.organization_id = orgid

Line 479: from mtl_material_transactions mmt,

475: round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
476: sum(1),
477: sum(abs(mmt.primary_quantity)),
478: round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
479: from mtl_material_transactions mmt,
480: mtl_txn_source_types mtst,
481: mfg_lookups ml,
482: mtl_transaction_types mtt
483: where mmt.organization_id = orgid

Line 636: from mtl_material_transactions mmt

632: round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
633: sum(1),
634: cratio*sum(abs(mmt.primary_quantity)),
635: round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
636: from mtl_material_transactions mmt
637: where mmt.subinventory_code = sub
638: and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
639: and mmt.organization_id = orgid
640: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)

Line 685: from mtl_material_transactions mmt

681: 'TOTALS',
682: round(nvl(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),0),prc),
683: nvl(sum(1),0),
684: 1
685: from mtl_material_transactions mmt
686: where mmt.organization_id = orgid
687: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
688: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
689: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)

Line 707: from mtl_material_transactions mmt

703: 'TOTALS',
704: round(nvl(abs(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity)),0),prc),
705: nvl(sum(1),0),
706: 2
707: from mtl_material_transactions mmt
708: where mmt.organization_id = orgid
709: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
710: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
711: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)

Line 729: from mtl_material_transactions mmt

725: 'TOTALS',
726: round(nvl(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),0),prc),
727: nvl(sum(1),0),
728: 1
729: from mtl_material_transactions mmt
730: where mmt.organization_id = orgid
731: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
732: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
733: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)

Line 757: from mtl_material_transactions mmt

753: 'TOTALS',
754: round(nvl(abs(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity)),0),prc),
755: nvl(sum(1),0),
756: 2
757: from mtl_material_transactions mmt
758: where mmt.organization_id = orgid
759: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
760: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
761: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)

Line 803: sdate mtl_material_transactions.transaction_date%TYPE,

799: uom mtl_system_items.primary_uom_code%TYPE,
800: puom mtl_system_items.primary_uom_code%TYPE,
801: sub mtl_secondary_inventories.secondary_inventory_name%TYPE,
802: locid mtl_item_locations.inventory_location_id%TYPE,
803: sdate mtl_material_transactions.transaction_date%TYPE,
804: edate mtl_material_transactions.transaction_date%TYPE,
805: cg_id mtl_secondary_inventories.default_cost_group_id%TYPE)
806: is
807: cratio number := 1;

Line 804: edate mtl_material_transactions.transaction_date%TYPE,

800: puom mtl_system_items.primary_uom_code%TYPE,
801: sub mtl_secondary_inventories.secondary_inventory_name%TYPE,
802: locid mtl_item_locations.inventory_location_id%TYPE,
803: sdate mtl_material_transactions.transaction_date%TYPE,
804: edate mtl_material_transactions.transaction_date%TYPE,
805: cg_id mtl_secondary_inventories.default_cost_group_id%TYPE)
806: is
807: cratio number := 1;
808: prc number := 1;

Line 850: from mtl_material_transactions mmt,

846: round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
847: sum(1),
848: cratio*sum(abs(mmt.primary_quantity)),
849: round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
850: from mtl_material_transactions mmt,
851: mtl_txn_source_types mtst,
852: mtl_transaction_types mtt,
853: mfg_lookups ml
854: where mmt.inventory_item_id = invid

Line 965: from mtl_material_transactions mmt

961: round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
962: sum(1),
963: cratio*sum(abs(mmt.primary_quantity)),
964: round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
965: from mtl_material_transactions mmt
966: where mmt.subinventory_code = sub
967: and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
968: and mmt.organization_id = orgid
969: and mmt.inventory_item_id = invid

Line 1017: from mtl_material_transactions mmt

1013: nvl(cratio*sum(mmt.primary_quantity),0),
1014: round(nvl(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),0),prc),
1015: nvl(sum(1),0),
1016: 1
1017: from mtl_material_transactions mmt
1018: where mmt.inventory_item_id = invid
1019: and mmt.organization_id = orgid
1020: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
1021: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)

Line 1044: from mtl_material_transactions mmt

1040: nvl(abs(cratio*sum(mmt.primary_quantity)),0),
1041: round(nvl(abs(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity)),0),prc),
1042: nvl(sum(1),0),
1043: 2
1044: from mtl_material_transactions mmt
1045: where mmt.inventory_item_id = invid
1046: and mmt.organization_id = orgid
1047: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
1048: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)

Line 1084: sdate mtl_material_transactions.transaction_date%TYPE,

1080: sessionid number,
1081: orgid mtl_parameters.organization_id%TYPE,
1082: orgloctype NUMBER,
1083: cost_group_id mtl_secondary_inventories.default_cost_group_id%TYPE,
1084: sdate mtl_material_transactions.transaction_date%TYPE,
1085: edate mtl_material_transactions.transaction_date%TYPE)
1086: IS
1087: msgbuf varchar2(200);
1088: cratio number := 1;

Line 1085: edate mtl_material_transactions.transaction_date%TYPE)

1081: orgid mtl_parameters.organization_id%TYPE,
1082: orgloctype NUMBER,
1083: cost_group_id mtl_secondary_inventories.default_cost_group_id%TYPE,
1084: sdate mtl_material_transactions.transaction_date%TYPE,
1085: edate mtl_material_transactions.transaction_date%TYPE)
1086: IS
1087: msgbuf varchar2(200);
1088: cratio number := 1;
1089: begin

Line 1121: from mtl_material_transactions mmt,

1117: sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),
1118: sum(1),
1119: sum(abs(mmt.primary_quantity)),
1120: sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity))
1121: from mtl_material_transactions mmt,
1122: mtl_txn_source_types mtst,
1123: mfg_lookups ml,
1124: mtl_transaction_types mtt
1125: where mmt.organization_id = orgid

Line 1243: from mtl_material_transactions mmt

1239: sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),
1240: sum(1),
1241: cratio*sum(abs(mmt.primary_quantity)),
1242: sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity))
1243: from mtl_material_transactions mmt
1244: where mmt.cost_group_id = cost_group_id
1245: and mmt.organization_id = orgid
1246: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
1247: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)

Line 1272: from mtl_material_transactions mmt

1268: sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),
1269: sum(1),
1270: cratio*sum(abs(mmt.primary_quantity)),
1271: sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity))
1272: from mtl_material_transactions mmt
1273: where mmt.cost_group_id = cost_group_id
1274: and mmt.organization_id = orgid
1275: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
1276: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)

Line 1328: from mtl_material_transactions mmt

1324: sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),
1325: sum(1),
1326: cratio*sum(abs(mmt.primary_quantity)),
1327: sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity))
1328: from mtl_material_transactions mmt
1329: where mmt.cost_group_id = cost_group_id
1330: and mmt.organization_id = orgid
1331: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
1332: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)

Line 1373: from mtl_material_transactions mmt

1369: 'TOTALS',
1370: nvl(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),0),
1371: nvl(sum(1),0),
1372: 1
1373: from mtl_material_transactions mmt
1374: where mmt.organization_id = orgid
1375: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
1376: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
1377: and mmt.cost_group_id = cost_group_id

Line 1393: from mtl_material_transactions mmt

1389: 'TOTALS',
1390: nvl(abs(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity)),0),
1391: nvl(sum(1),0),
1392: 2
1393: from mtl_material_transactions mmt
1394: where mmt.organization_id = orgid
1395: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
1396: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
1397: and mmt.cost_group_id = cost_group_id

Line 1426: sdate mtl_material_transactions.transaction_date%TYPE,

1422: sessionid NUMBER,
1423: orgid mtl_parameters.organization_id%TYPE,
1424: sub mtl_secondary_inventories.secondary_inventory_name%TYPE,
1425: cost_group_id mtl_secondary_inventories.default_cost_group_id%TYPE,
1426: sdate mtl_material_transactions.transaction_date%TYPE,
1427: edate mtl_material_transactions.transaction_date%TYPE)
1428: IS
1429: msgbuf varchar2(200);
1430: begin

Line 1427: edate mtl_material_transactions.transaction_date%TYPE)

1423: orgid mtl_parameters.organization_id%TYPE,
1424: sub mtl_secondary_inventories.secondary_inventory_name%TYPE,
1425: cost_group_id mtl_secondary_inventories.default_cost_group_id%TYPE,
1426: sdate mtl_material_transactions.transaction_date%TYPE,
1427: edate mtl_material_transactions.transaction_date%TYPE)
1428: IS
1429: msgbuf varchar2(200);
1430: begin
1431:

Line 1463: from mtl_material_transactions mmt,

1459: sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),
1460: sum(1),
1461: sum(abs(mmt.primary_quantity)),
1462: sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity))
1463: from mtl_material_transactions mmt,
1464: mtl_txn_source_types mtst,
1465: mfg_lookups ml,
1466: mtl_transaction_types mtt
1467: where mmt.organization_id = orgid

Line 1581: from mtl_material_transactions mmt

1577: 'TOTALS',
1578: nvl(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),0),
1579: nvl(sum(1),0),
1580: 1
1581: from mtl_material_transactions mmt
1582: where mmt.organization_id = orgid
1583: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
1584: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
1585: and mmt.subinventory_code = sub

Line 1602: from mtl_material_transactions mmt

1598: 'TOTALS',
1599: nvl(abs(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity)),0),
1600: nvl(sum(1),0),
1601: 2
1602: from mtl_material_transactions mmt
1603: where mmt.organization_id = orgid
1604: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
1605: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
1606: and mmt.subinventory_code = sub