APPS.INV_MO_BACKORDER_PVT dependencies on DUAL

Line 167: SELECT 'N' FROM DUAL

163: l_mo_type NUMBER;
164: l_allow_backordering VARCHAR2(1) := 'Y';
165:
166: CURSOR c_allow_backordering IS
167: SELECT 'N' FROM DUAL
168: WHERE EXISTS( SELECT 1
169: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt
170: WHERE mmtt.move_order_line_id = l_mo_line_rec.line_id
171: AND wdt.transaction_temp_id = nvl(mmtt.parent_line_id, mmtt.transaction_temp_id)

Line 276: -- Fork the update statement below according to whether item tracks dual qty or not

272: debug('Updating Move Order Line Quantity = ' || l_mo_line_rec.quantity_delivered, 'BACKORDER');
273: debug('Updating Move Order Line Secondary Qty = ' || l_mo_line_rec.secondary_quantity_delivered, 'BACKORDER'); -- INVCONV
274: END IF;
275: -- INVCONV BEGIN
276: -- Fork the update statement below according to whether item tracks dual qty or not
277: IF l_mo_line_rec.secondary_uom IS NULL THEN
278: -- INVCONV Tracking in primary only
279: UPDATE mtl_txn_request_lines
280: SET line_status = 5

Line 474: -- For dual control items, compute the secondary detailed

470: IF(l_rsv_detailed_qty > ABS(l_umconvert_trans_quantity)) THEN
471: l_mtl_reservation_tbl(1).detailed_quantity :=
472: l_rsv_detailed_qty - ABS(l_umconvert_trans_quantity);
473: -- INVCONV BEGIN
474: -- For dual control items, compute the secondary detailed
475: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
476: l_mtl_reservation_tbl(1).secondary_detailed_quantity :=
477: l_rsv_secondary_detailed_qty - ABS(p_secondary_trx_qty);
478: END IF;

Line 543: -- For dual control items, compute the secondary detailed

539: IF(l_rsv_detailed_qty > ABS(p_transaction_quantity)) THEN
540: l_mtl_reservation_tbl(1).detailed_quantity :=
541: l_rsv_detailed_qty - ABS(p_transaction_quantity);
542: -- INVCONV BEGIN
543: -- For dual control items, compute the secondary detailed
544: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
545: l_mtl_reservation_tbl(1).secondary_detailed_quantity :=
546: l_rsv_secondary_detailed_qty - ABS(p_secondary_trx_qty);
547: END IF;

Line 552: -- For dual control items, zero the secondary detailed

548: -- INVCONV END
549: ELSE
550: l_mtl_reservation_tbl(1).detailed_quantity := 0;
551: -- INVCONV BEGIN
552: -- For dual control items, zero the secondary detailed
553: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
554: l_mtl_reservation_tbl(1).secondary_detailed_quantity := 0;
555: END IF;
556: -- INVCONV END

Line 563: -- For dual control items, compute the secondary reservation qty

559: IF(l_rsv_reservation_qty > ABS(l_umconvert_trans_quantity)) THEN
560: l_mtl_reservation_tbl(1).reservation_quantity :=
561: l_rsv_reservation_qty - ABS(l_umconvert_trans_quantity);
562: -- INVCONV BEGIN
563: -- For dual control items, compute the secondary reservation qty
564: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
565: l_mtl_reservation_tbl(1).secondary_reservation_quantity :=
566: l_rsv_sec_reservation_qty - ABS(p_secondary_trx_qty);
567: END IF;

Line 572: -- For dual control items, zero the secondary reservation qty

568: -- INVCONV END
569: ELSE
570: l_mtl_reservation_tbl(1).reservation_quantity := 0;
571: -- INVCONV BEGIN
572: -- For dual control items, zero the secondary reservation qty
573: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
574: l_mtl_reservation_tbl(1).secondary_reservation_quantity := 0;
575: END IF;
576: -- INVCONV END