[Home] [Help]
460: l_mmtt_qty_part := ' mmtt.primary_quantity ';
461: l_mtlt_qty_part := ' mtlt.primary_quantity ';
462: ELSE
463: l_onhand_qty_part := ' decode(:demand_source_line_id, NULL,
464: sum(moq.primary_transaction_quantity), pjm_ueff_onhand.onhand_quantity
465: (:demand_source_line_id,moq.inventory_item_id,moq.organization_id
466: ,moq.revision,moq.subinventory_code,moq.locator_id,moq.lot_number,moq.lpn_id,moq.cost_group_id)
467: ) ';
468: l_mmtt_qty_part := ' decode(:demand_source_line_id, NULL, mmtt.primary_quantity, Nvl(pjm_ueff_onhand.txn_quantity(:demand_source_line_id,mmtt.transaction_temp_id,mmtt.lot_number,
464: sum(moq.primary_transaction_quantity), pjm_ueff_onhand.onhand_quantity
465: (:demand_source_line_id,moq.inventory_item_id,moq.organization_id
466: ,moq.revision,moq.subinventory_code,moq.locator_id,moq.lot_number,moq.lpn_id,moq.cost_group_id)
467: ) ';
468: l_mmtt_qty_part := ' decode(:demand_source_line_id, NULL, mmtt.primary_quantity, Nvl(pjm_ueff_onhand.txn_quantity(:demand_source_line_id,mmtt.transaction_temp_id,mmtt.lot_number,
469: ''Y'',mmtt.inventory_item_id, mmtt.organization_id, mmtt.transaction_source_type_id,
470: mmtt.transaction_source_id, mmtt.rcv_transaction_id,
471: sign(mmtt.primary_quantity)
472: ),mmtt.primary_quantity)) ';
469: ''Y'',mmtt.inventory_item_id, mmtt.organization_id, mmtt.transaction_source_type_id,
470: mmtt.transaction_source_id, mmtt.rcv_transaction_id,
471: sign(mmtt.primary_quantity)
472: ),mmtt.primary_quantity)) ';
473: l_mtlt_qty_part := ' decode(:demand_source_line_id, NULL, mtlt.primary_quantity, Nvl(pjm_ueff_onhand.txn_quantity(:demand_source_line_id,mmtt.transaction_temp_id,mtlt.lot_number,
474: ''Y'',mmtt.inventory_item_id, mmtt.organization_id, mmtt.transaction_source_type_id,
475: mmtt.transaction_source_id, mmtt.rcv_transaction_id,
476: sign(mmtt.primary_quantity)
477: ) ,mtlt.primary_quantity)) ';
7009: , moq.subinventory_code subinventory_code
7010: , moq.locator_id locator_id
7011: , decode(l_demand_source_line_id,
7012: NULL, sum(moq.primary_transaction_quantity),
7013: pjm_ueff_onhand.onhand_quantity(
7014: l_demand_source_line_id
7015: ,moq.inventory_item_id
7016: ,moq.organization_id
7017: ,moq.revision
7022: ,moq.cost_group_id)
7023: )
7024: , decode(l_demand_source_line_id,
7025: NULL, sum(moq.secondary_transaction_quantity),
7026: pjm_ueff_onhand.onhand_quantity(
7027: l_demand_source_line_id
7028: ,moq.inventory_item_id
7029: ,moq.organization_id
7030: ,moq.revision
7060: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7061: Sign(mmtt.primary_quantity))) *
7062: round(Abs(decode(l_demand_source_line_id,
7063: NULL, mmtt.primary_quantity,
7064: Nvl(pjm_ueff_onhand.txn_quantity(
7065: l_demand_source_line_id
7066: ,mmtt.transaction_temp_id
7067: ,mmtt.lot_number
7068: ,'Y'
7081: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7082: Sign(mmtt.secondary_transaction_quantity))) *
7083: round(Abs(decode(l_demand_source_line_id,
7084: NULL, mmtt.secondary_transaction_quantity,
7085: Nvl(pjm_ueff_onhand.txn_quantity(
7086: l_demand_source_line_id
7087: ,mmtt.transaction_temp_id
7088: ,mmtt.lot_number
7089: ,'Y'
7132: , mmtt.transfer_subinventory subinventory_code
7133: , mmtt.transfer_to_location locator_id
7134: , round(Abs(decode(l_demand_source_line_id,
7135: NULL, mmtt.primary_quantity,
7136: Nvl(pjm_ueff_onhand.txn_quantity(
7137: l_demand_source_line_id
7138: ,mmtt.transaction_temp_id
7139: ,mmtt.lot_number
7140: ,'Y'
7148: )
7149: )),5)
7150: , round(Abs(decode(l_demand_source_line_id,
7151: NULL, mmtt.secondary_transaction_quantity,
7152: Nvl(pjm_ueff_onhand.txn_quantity(
7153: l_demand_source_line_id
7154: ,mmtt.transaction_temp_id
7155: ,mmtt.lot_number
7156: ,'Y'
7292: , moq.subinventory_code subinventory_code
7293: , moq.locator_id locator_id
7294: , decode(l_demand_source_line_id,
7295: NULL, sum(moq.primary_transaction_quantity),
7296: pjm_ueff_onhand.onhand_quantity(
7297: l_demand_source_line_id
7298: ,moq.inventory_item_id
7299: ,moq.organization_id
7300: ,moq.revision
7305: ,moq.cost_group_id)
7306: )
7307: , decode(l_demand_source_line_id,
7308: NULL, sum(moq.secondary_transaction_quantity),
7309: pjm_ueff_onhand.onhand_quantity(
7310: l_demand_source_line_id
7311: ,moq.inventory_item_id
7312: ,moq.organization_id
7313: ,moq.revision
7343: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7344: Sign(mmtt.primary_quantity))) *
7345: round(Abs(decode(l_demand_source_line_id,
7346: NULL, mmtt.primary_quantity,
7347: Nvl(pjm_ueff_onhand.txn_quantity(
7348: l_demand_source_line_id
7349: ,mmtt.transaction_temp_id
7350: ,mmtt.lot_number
7351: ,'Y'
7364: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7365: Sign(mmtt.secondary_transaction_quantity))) *
7366: round(Abs(decode(l_demand_source_line_id,
7367: NULL, mmtt.secondary_transaction_quantity,
7368: Nvl(pjm_ueff_onhand.txn_quantity(
7369: l_demand_source_line_id
7370: ,mmtt.transaction_temp_id
7371: ,mmtt.lot_number
7372: ,'Y'
7416: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7417: Sign(mmtt.primary_quantity))) *
7418: round(Abs(decode(l_demand_source_line_id,
7419: NULL, mtlt.primary_quantity,
7420: Nvl(pjm_ueff_onhand.txn_quantity(
7421: l_demand_source_line_id
7422: ,mmtt.transaction_temp_id
7423: ,mtlt.lot_number
7424: ,'Y'
7436: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7437: Sign(mmtt.secondary_transaction_quantity))) *
7438: round(Abs(decode(l_demand_source_line_id,
7439: NULL, mtlt.secondary_quantity,
7440: Nvl(pjm_ueff_onhand.txn_quantity(
7441: l_demand_source_line_id
7442: ,mmtt.transaction_temp_id
7443: ,mtlt.lot_number
7444: ,'Y'
7487: , mmtt.transfer_subinventory subinventory_code
7488: , mmtt.transfer_to_location locator_id
7489: , round(Abs(decode(l_demand_source_line_id,
7490: NULL, mmtt.primary_quantity,
7491: Nvl(pjm_ueff_onhand.txn_quantity(
7492: l_demand_source_line_id
7493: ,mmtt.transaction_temp_id
7494: ,mmtt.lot_number
7495: ,'Y'
7502: ),mmtt.primary_quantity)
7503: )),5)
7504: , round(Abs(decode(l_demand_source_line_id,
7505: NULL, mmtt.secondary_transaction_quantity,
7506: Nvl(pjm_ueff_onhand.txn_quantity(
7507: l_demand_source_line_id
7508: ,mmtt.transaction_temp_id
7509: ,mmtt.lot_number
7510: ,'Y'
7544: , mmtt.transfer_subinventory subinventory_code
7545: , mmtt.transfer_to_location locator_id
7546: , round(Abs(decode(l_demand_source_line_id,
7547: NULL, mtlt.primary_quantity,
7548: Nvl(pjm_ueff_onhand.txn_quantity(
7549: l_demand_source_line_id
7550: ,mmtt.transaction_temp_id
7551: ,mtlt.lot_number
7552: ,'Y'
7559: ),mtlt.primary_quantity)
7560: )),5)
7561: , round(Abs(decode(l_demand_source_line_id,
7562: NULL, mtlt.secondary_quantity,
7563: Nvl(pjm_ueff_onhand.txn_quantity(
7564: l_demand_source_line_id
7565: ,mmtt.transaction_temp_id
7566: ,mtlt.lot_number
7567: ,'Y'
7712: , moq.subinventory_code subinventory_code
7713: , moq.locator_id locator_id
7714: , decode(l_demand_source_line_id,
7715: NULL, sum(moq.primary_transaction_quantity),
7716: pjm_ueff_onhand.onhand_quantity(
7717: l_demand_source_line_id
7718: ,moq.inventory_item_id
7719: ,moq.organization_id
7720: ,moq.revision
7725: ,moq.cost_group_id)
7726: )
7727: , decode(l_demand_source_line_id,
7728: NULL, sum(moq.secondary_transaction_quantity),
7729: pjm_ueff_onhand.onhand_quantity(
7730: l_demand_source_line_id
7731: ,moq.inventory_item_id
7732: ,moq.organization_id
7733: ,moq.revision
7763: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7764: Sign(mmtt.primary_quantity))) *
7765: round(Abs(decode(l_demand_source_line_id,
7766: NULL, mmtt.primary_quantity,
7767: Nvl(pjm_ueff_onhand.txn_quantity(
7768: l_demand_source_line_id
7769: ,mmtt.transaction_temp_id
7770: ,mmtt.lot_number
7771: ,'Y'
7784: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7785: Sign(mmtt.secondary_transaction_quantity))) *
7786: round(Abs(decode(l_demand_source_line_id,
7787: NULL, mmtt.secondary_transaction_quantity,
7788: Nvl(pjm_ueff_onhand.txn_quantity(
7789: l_demand_source_line_id
7790: ,mmtt.transaction_temp_id
7791: ,mmtt.lot_number
7792: ,'Y'
7836: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7837: Sign(mmtt.primary_quantity))) *
7838: round(Abs(decode(l_demand_source_line_id,
7839: NULL, mtlt.primary_quantity,
7840: Nvl(pjm_ueff_onhand.txn_quantity(
7841: l_demand_source_line_id
7842: ,mmtt.transaction_temp_id
7843: ,mtlt.lot_number
7844: ,'Y'
7856: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
7857: Sign(mmtt.secondary_transaction_quantity))) *
7858: round(Abs(decode(l_demand_source_line_id,
7859: NULL, mtlt.secondary_quantity,
7860: Nvl(pjm_ueff_onhand.txn_quantity(
7861: l_demand_source_line_id
7862: ,mmtt.transaction_temp_id
7863: ,mtlt.lot_number
7864: ,'Y'
7907: , mmtt.transfer_subinventory subinventory_code
7908: , mmtt.transfer_to_location locator_id
7909: , round(Abs(decode(l_demand_source_line_id,
7910: NULL, mmtt.primary_quantity,
7911: Nvl(pjm_ueff_onhand.txn_quantity(
7912: l_demand_source_line_id
7913: ,mmtt.transaction_temp_id
7914: ,mmtt.lot_number
7915: ,'Y'
7922: ),mmtt.primary_quantity)
7923: )),5)
7924: , round(Abs(decode(l_demand_source_line_id,
7925: NULL, mmtt.secondary_transaction_quantity,
7926: Nvl(pjm_ueff_onhand.txn_quantity(
7927: l_demand_source_line_id
7928: ,mmtt.transaction_temp_id
7929: ,mmtt.lot_number
7930: ,'Y'
7964: , mmtt.transfer_subinventory subinventory_code
7965: , mmtt.transfer_to_location locator_id
7966: , round(Abs(decode(l_demand_source_line_id,
7967: NULL, mtlt.primary_quantity,
7968: Nvl(pjm_ueff_onhand.txn_quantity(
7969: l_demand_source_line_id
7970: ,mmtt.transaction_temp_id
7971: ,mtlt.lot_number
7972: ,'Y'
7979: ),mtlt.primary_quantity)
7980: )),5)
7981: , round(Abs(decode(l_demand_source_line_id,
7982: NULL, mtlt.secondary_quantity,
7983: Nvl(pjm_ueff_onhand.txn_quantity(
7984: l_demand_source_line_id
7985: ,mmtt.transaction_temp_id
7986: ,mtlt.lot_number
7987: ,'Y'