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 488: -- For dual control items, compute the secondary detailed

484: IF(l_rsv_detailed_qty > ABS(l_umconvert_trans_quantity)) THEN
485: l_mtl_reservation_tbl(1).detailed_quantity :=
486: l_rsv_detailed_qty - ABS(l_umconvert_trans_quantity);
487: -- INVCONV BEGIN
488: -- For dual control items, compute the secondary detailed
489: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
490: l_mtl_reservation_tbl(1).secondary_detailed_quantity :=
491: l_rsv_secondary_detailed_qty - ABS(p_secondary_trx_qty);
492: END IF;

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

553: IF(l_rsv_detailed_qty > ABS(p_transaction_quantity)) THEN
554: l_mtl_reservation_tbl(1).detailed_quantity :=
555: l_rsv_detailed_qty - ABS(p_transaction_quantity);
556: -- INVCONV BEGIN
557: -- For dual control items, compute the secondary detailed
558: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
559: l_mtl_reservation_tbl(1).secondary_detailed_quantity :=
560: l_rsv_secondary_detailed_qty - ABS(p_secondary_trx_qty);
561: END IF;

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

562: -- INVCONV END
563: ELSE
564: l_mtl_reservation_tbl(1).detailed_quantity := 0;
565: -- INVCONV BEGIN
566: -- For dual control items, zero the secondary detailed
567: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
568: l_mtl_reservation_tbl(1).secondary_detailed_quantity := 0;
569: END IF;
570: -- INVCONV END

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

573: IF(l_rsv_reservation_qty > ABS(l_umconvert_trans_quantity)) THEN
574: l_mtl_reservation_tbl(1).reservation_quantity :=
575: l_rsv_reservation_qty - ABS(l_umconvert_trans_quantity);
576: -- INVCONV BEGIN
577: -- For dual control items, compute the secondary reservation qty
578: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
579: l_mtl_reservation_tbl(1).secondary_reservation_quantity :=
580: l_rsv_sec_reservation_qty - ABS(p_secondary_trx_qty);
581: END IF;

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

582: -- INVCONV END
583: ELSE
584: l_mtl_reservation_tbl(1).reservation_quantity := 0;
585: -- INVCONV BEGIN
586: -- For dual control items, zero the secondary reservation qty
587: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
588: l_mtl_reservation_tbl(1).secondary_reservation_quantity := 0;
589: END IF;
590: -- INVCONV END