[Home] [Help]
435: SELECT whse, item, qty
436: FROM ( /* current inventory transfers */
437: -- Current intransit inventory transfer activity is determined by
438: -- the transfer_status = 2 for a transfer_id in the
439: -- transfer master table, IC_XFER_MST. The transfer_id
440: -- is the same as the doc_id in the pending transaction tables,
441: -- IC_TRAN_PND. Since the FOB = 'Receipt'
442: -- always, only the shipment lines in the transaction
443: -- tables will contribute to the intransit inventory of the
453: pnd.item_id item,
454: (-1 * pnd.trans_qty) qty
455: FROM
456: ic_tran_pnd pnd,
457: ic_xfer_mst xfer,
458: sy_orgn_mst o,
459: opi_dbi_inv_value_log sd
460: WHERE
461: pnd.doc_id = xfer.transfer_id
539: -- inventory transfer transactions i.e. with doc_type = 'XFER'
540: -- The transactions must be after the collection start date.
541: -- Since the FOB = 'Receipt' always and receipt transactions
542: -- i.e. those with line_type = 2, are associated with the receiving
543: -- warehouse, we need to join to the transfer master, ic_xfer_mst,
544: -- to figure out the shipping org whose intransit balance is
545: -- affected. For consistency with the all other modules, we look
546: -- at pending transactions where completed_ind = 1.
547: -- The pnd/cmp tables store -ve quantities for shipments which
552: pnd.item_id item,
553: (-1 * pnd.trans_qty) qty
554: FROM
555: ic_tran_vw1 pnd,
556: ic_xfer_mst xfer,
557: sy_orgn_mst o,
558: opi_dbi_inv_value_log sd
559: WHERE pnd.completed_ind = 1 -- completed transfer
560: -- view sets completed_ind to 1