[Home] [Help]
5264: , moq.subinventory_code subinventory_code
5265: , moq.locator_id locator_id
5266: , decode(l_demand_source_line_id,
5267: NULL, sum(moq.primary_transaction_quantity),
5268: pjm_ueff_onhand.onhand_quantity(
5269: l_demand_source_line_id
5270: ,moq.inventory_item_id
5271: ,moq.organization_id
5272: ,moq.revision
5277: ,moq.cost_group_id)
5278: )
5279: , decode(l_demand_source_line_id,
5280: NULL, sum(moq.secondary_transaction_quantity),
5281: pjm_ueff_onhand.onhand_quantity(
5282: l_demand_source_line_id
5283: ,moq.inventory_item_id
5284: ,moq.organization_id
5285: ,moq.revision
5315: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
5316: Sign(mmtt.primary_quantity))) *
5317: round(Abs(decode(l_demand_source_line_id,
5318: NULL, mmtt.primary_quantity,
5319: Nvl(pjm_ueff_onhand.txn_quantity(
5320: l_demand_source_line_id
5321: ,mmtt.transaction_temp_id
5322: ,mmtt.lot_number
5323: ,'Y'
5336: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
5337: Sign(mmtt.secondary_transaction_quantity))) *
5338: round(Abs(decode(l_demand_source_line_id,
5339: NULL, mmtt.secondary_transaction_quantity,
5340: Nvl(pjm_ueff_onhand.txn_quantity(
5341: l_demand_source_line_id
5342: ,mmtt.transaction_temp_id
5343: ,mmtt.lot_number
5344: ,'Y'
5399: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
5400: Sign(mmtt.primary_quantity))) *
5401: round(Abs(decode(l_demand_source_line_id,
5402: NULL, mtlt.primary_quantity,
5403: Nvl(pjm_ueff_onhand.txn_quantity(
5404: l_demand_source_line_id
5405: ,mmtt.transaction_temp_id
5406: ,mtlt.lot_number
5407: ,'Y'
5419: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
5420: Sign(mmtt.secondary_transaction_quantity))) *
5421: round(Abs(decode(l_demand_source_line_id,
5422: NULL, mtlt.secondary_quantity,
5423: Nvl(pjm_ueff_onhand.txn_quantity(
5424: l_demand_source_line_id
5425: ,mmtt.transaction_temp_id
5426: ,mtlt.lot_number
5427: ,'Y'
5480: , mmtt.subinventory_code subinventory_code
5481: , mmtt.locator_id locator_id
5482: , -1 * round(Abs(decode (l_demand_source_line_id,
5483: NULL, mmtt.primary_quantity,
5484: Nvl(pjm_ueff_onhand.txn_quantity
5485: (l_demand_source_line_id
5486: ,mmtt.transaction_temp_id
5487: ,mmtt.lot_number
5488: ,'Y'
5498: ),5
5499: )
5500: , -1 * round(Abs(decode (l_demand_source_line_id,
5501: NULL, mmtt.secondary_transaction_quantity,
5502: Nvl(pjm_ueff_onhand.txn_quantity
5503: (l_demand_source_line_id
5504: ,mmtt.transaction_temp_id
5505: ,mmtt.lot_number
5506: ,'Y'
5547: , mmtt.transfer_subinventory subinventory_code
5548: , mmtt.transfer_to_location locator_id
5549: , round(Abs(decode(l_demand_source_line_id,
5550: NULL, mmtt.primary_quantity,
5551: Nvl(pjm_ueff_onhand.txn_quantity(
5552: l_demand_source_line_id
5553: ,mmtt.transaction_temp_id
5554: ,mmtt.lot_number
5555: ,'Y'
5562: ),mmtt.primary_quantity)
5563: )),5)
5564: , round(Abs(decode(l_demand_source_line_id,
5565: NULL, mmtt.secondary_transaction_quantity,
5566: Nvl(pjm_ueff_onhand.txn_quantity(
5567: l_demand_source_line_id
5568: ,mmtt.transaction_temp_id
5569: ,mmtt.lot_number
5570: ,'Y'
5612: , mmtt.transfer_subinventory subinventory_code
5613: , mmtt.transfer_to_location locator_id
5614: , round(Abs(decode(l_demand_source_line_id,
5615: NULL, mtlt.primary_quantity,
5616: Nvl(pjm_ueff_onhand.txn_quantity(
5617: l_demand_source_line_id
5618: ,mmtt.transaction_temp_id
5619: ,mtlt.lot_number
5620: ,'Y'
5627: ),mtlt.primary_quantity)
5628: )),5)
5629: , round(Abs(decode(l_demand_source_line_id,
5630: NULL, mtlt.secondary_quantity,
5631: Nvl(pjm_ueff_onhand.txn_quantity(
5632: l_demand_source_line_id
5633: ,mmtt.transaction_temp_id
5634: ,mtlt.lot_number
5635: ,'Y'
7285: , moq.subinventory_code subinventory_code
7286: , moq.locator_id locator_id
7287: , decode(l_demand_source_line_id,
7288: NULL, sum(moq.primary_transaction_quantity),
7289: pjm_ueff_onhand.onhand_quantity(
7290: l_demand_source_line_id
7291: ,moq.inventory_item_id
7292: ,moq.organization_id
7293: ,moq.revision
7298: ,moq.cost_group_id)
7299: )
7300: , decode(l_demand_source_line_id,
7301: NULL, sum(moq.secondary_transaction_quantity),
7302: pjm_ueff_onhand.onhand_quantity(
7303: l_demand_source_line_id
7304: ,moq.inventory_item_id
7305: ,moq.organization_id
7306: ,moq.revision
7336: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7337: Sign(mmtt.primary_quantity))) *
7338: round(Abs(decode(l_demand_source_line_id,
7339: NULL, mmtt.primary_quantity,
7340: Nvl(pjm_ueff_onhand.txn_quantity(
7341: l_demand_source_line_id
7342: ,mmtt.transaction_temp_id
7343: ,mmtt.lot_number
7344: ,'Y'
7357: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7358: Sign(mmtt.secondary_transaction_quantity))) *
7359: round(Abs(decode(l_demand_source_line_id,
7360: NULL, mmtt.secondary_transaction_quantity,
7361: Nvl(pjm_ueff_onhand.txn_quantity(
7362: l_demand_source_line_id
7363: ,mmtt.transaction_temp_id
7364: ,mmtt.lot_number
7365: ,'Y'
7419: , mmtt.transfer_subinventory subinventory_code
7420: , mmtt.transfer_to_location locator_id
7421: , round(Abs(decode(l_demand_source_line_id,
7422: NULL, mmtt.primary_quantity,
7423: Nvl(pjm_ueff_onhand.txn_quantity(
7424: l_demand_source_line_id
7425: ,mmtt.transaction_temp_id
7426: ,mmtt.lot_number
7427: ,'Y'
7435: )
7436: )),5)
7437: , round(Abs(decode(l_demand_source_line_id,
7438: NULL, mmtt.secondary_transaction_quantity,
7439: Nvl(pjm_ueff_onhand.txn_quantity(
7440: l_demand_source_line_id
7441: ,mmtt.transaction_temp_id
7442: ,mmtt.lot_number
7443: ,'Y'
7588: , moq.subinventory_code subinventory_code
7589: , moq.locator_id locator_id
7590: , decode(l_demand_source_line_id,
7591: NULL, sum(moq.primary_transaction_quantity),
7592: pjm_ueff_onhand.onhand_quantity(
7593: l_demand_source_line_id
7594: ,moq.inventory_item_id
7595: ,moq.organization_id
7596: ,moq.revision
7601: ,moq.cost_group_id)
7602: )
7603: , decode(l_demand_source_line_id,
7604: NULL, sum(moq.secondary_transaction_quantity),
7605: pjm_ueff_onhand.onhand_quantity(
7606: l_demand_source_line_id
7607: ,moq.inventory_item_id
7608: ,moq.organization_id
7609: ,moq.revision
7639: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7640: Sign(mmtt.primary_quantity))) *
7641: round(Abs(decode(l_demand_source_line_id,
7642: NULL, mmtt.primary_quantity,
7643: Nvl(pjm_ueff_onhand.txn_quantity(
7644: l_demand_source_line_id
7645: ,mmtt.transaction_temp_id
7646: ,mmtt.lot_number
7647: ,'Y'
7660: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7661: Sign(mmtt.secondary_transaction_quantity))) *
7662: round(Abs(decode(l_demand_source_line_id,
7663: NULL, mmtt.secondary_transaction_quantity,
7664: Nvl(pjm_ueff_onhand.txn_quantity(
7665: l_demand_source_line_id
7666: ,mmtt.transaction_temp_id
7667: ,mmtt.lot_number
7668: ,'Y'
7723: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7724: Sign(mmtt.primary_quantity))) *
7725: round(Abs(decode(l_demand_source_line_id,
7726: NULL, mtlt.primary_quantity,
7727: Nvl(pjm_ueff_onhand.txn_quantity(
7728: l_demand_source_line_id
7729: ,mmtt.transaction_temp_id
7730: ,mtlt.lot_number
7731: ,'Y'
7743: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7744: Sign(mmtt.secondary_transaction_quantity))) *
7745: round(Abs(decode(l_demand_source_line_id,
7746: NULL, mtlt.secondary_quantity,
7747: Nvl(pjm_ueff_onhand.txn_quantity(
7748: l_demand_source_line_id
7749: ,mmtt.transaction_temp_id
7750: ,mtlt.lot_number
7751: ,'Y'
7805: , mmtt.transfer_subinventory subinventory_code
7806: , mmtt.transfer_to_location locator_id
7807: , round(Abs(decode(l_demand_source_line_id,
7808: NULL, mmtt.primary_quantity,
7809: Nvl(pjm_ueff_onhand.txn_quantity(
7810: l_demand_source_line_id
7811: ,mmtt.transaction_temp_id
7812: ,mmtt.lot_number
7813: ,'Y'
7820: ),mmtt.primary_quantity)
7821: )),5)
7822: , round(Abs(decode(l_demand_source_line_id,
7823: NULL, mmtt.secondary_transaction_quantity,
7824: Nvl(pjm_ueff_onhand.txn_quantity(
7825: l_demand_source_line_id
7826: ,mmtt.transaction_temp_id
7827: ,mmtt.lot_number
7828: ,'Y'
7870: , mmtt.transfer_subinventory subinventory_code
7871: , mmtt.transfer_to_location locator_id
7872: , round(Abs(decode(l_demand_source_line_id,
7873: NULL, mtlt.primary_quantity,
7874: Nvl(pjm_ueff_onhand.txn_quantity(
7875: l_demand_source_line_id
7876: ,mmtt.transaction_temp_id
7877: ,mtlt.lot_number
7878: ,'Y'
7885: ),mtlt.primary_quantity)
7886: )),5)
7887: , round(Abs(decode(l_demand_source_line_id,
7888: NULL, mtlt.secondary_quantity,
7889: Nvl(pjm_ueff_onhand.txn_quantity(
7890: l_demand_source_line_id
7891: ,mmtt.transaction_temp_id
7892: ,mtlt.lot_number
7893: ,'Y'
8044: , moq.subinventory_code subinventory_code
8045: , moq.locator_id locator_id
8046: , decode(l_demand_source_line_id,
8047: NULL, sum(moq.primary_transaction_quantity),
8048: pjm_ueff_onhand.onhand_quantity(
8049: l_demand_source_line_id
8050: ,moq.inventory_item_id
8051: ,moq.organization_id
8052: ,moq.revision
8057: ,moq.cost_group_id)
8058: )
8059: , decode(l_demand_source_line_id,
8060: NULL, sum(moq.secondary_transaction_quantity),
8061: pjm_ueff_onhand.onhand_quantity(
8062: l_demand_source_line_id
8063: ,moq.inventory_item_id
8064: ,moq.organization_id
8065: ,moq.revision
8095: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
8096: Sign(mmtt.primary_quantity))) *
8097: round(Abs(decode(l_demand_source_line_id,
8098: NULL, mmtt.primary_quantity,
8099: Nvl(pjm_ueff_onhand.txn_quantity(
8100: l_demand_source_line_id
8101: ,mmtt.transaction_temp_id
8102: ,mmtt.lot_number
8103: ,'Y'
8116: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
8117: Sign(mmtt.secondary_transaction_quantity))) *
8118: round(Abs(decode(l_demand_source_line_id,
8119: NULL, mmtt.secondary_transaction_quantity,
8120: Nvl(pjm_ueff_onhand.txn_quantity(
8121: l_demand_source_line_id
8122: ,mmtt.transaction_temp_id
8123: ,mmtt.lot_number
8124: ,'Y'
8179: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
8180: Sign(mmtt.primary_quantity))) *
8181: round(Abs(decode(l_demand_source_line_id,
8182: NULL, mtlt.primary_quantity,
8183: Nvl(pjm_ueff_onhand.txn_quantity(
8184: l_demand_source_line_id
8185: ,mmtt.transaction_temp_id
8186: ,mtlt.lot_number
8187: ,'Y'
8199: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
8200: Sign(mmtt.secondary_transaction_quantity))) *
8201: round(Abs(decode(l_demand_source_line_id,
8202: NULL, mtlt.secondary_quantity,
8203: Nvl(pjm_ueff_onhand.txn_quantity(
8204: l_demand_source_line_id
8205: ,mmtt.transaction_temp_id
8206: ,mtlt.lot_number
8207: ,'Y'
8261: , mmtt.transfer_subinventory subinventory_code
8262: , mmtt.transfer_to_location locator_id
8263: , round(Abs(decode(l_demand_source_line_id,
8264: NULL, mmtt.primary_quantity,
8265: Nvl(pjm_ueff_onhand.txn_quantity(
8266: l_demand_source_line_id
8267: ,mmtt.transaction_temp_id
8268: ,mmtt.lot_number
8269: ,'Y'
8276: ),mmtt.primary_quantity)
8277: )),5)
8278: , round(Abs(decode(l_demand_source_line_id,
8279: NULL, mmtt.secondary_transaction_quantity,
8280: Nvl(pjm_ueff_onhand.txn_quantity(
8281: l_demand_source_line_id
8282: ,mmtt.transaction_temp_id
8283: ,mmtt.lot_number
8284: ,'Y'
8326: , mmtt.transfer_subinventory subinventory_code
8327: , mmtt.transfer_to_location locator_id
8328: , round(Abs(decode(l_demand_source_line_id,
8329: NULL, mtlt.primary_quantity,
8330: Nvl(pjm_ueff_onhand.txn_quantity(
8331: l_demand_source_line_id
8332: ,mmtt.transaction_temp_id
8333: ,mtlt.lot_number
8334: ,'Y'
8341: ),mtlt.primary_quantity)
8342: )),5)
8343: , round(Abs(decode(l_demand_source_line_id,
8344: NULL, mtlt.secondary_quantity,
8345: Nvl(pjm_ueff_onhand.txn_quantity(
8346: l_demand_source_line_id
8347: ,mmtt.transaction_temp_id
8348: ,mtlt.lot_number
8349: ,'Y'