APPS.RCV_SHIPMENT_LINES_PKG dependencies on MTL_SUPPLY

Line 267: MTL_SUPPLY

263: TO_ORGANIZATION_ID,
264: TO_CHAR(RECEIPT_DATE,'DDMMYYYY'),
265: ROWID
266: FROM
267: MTL_SUPPLY
268: WHERE CHANGE_FLAG = 'Y';
269:
270: l_supply_qty number;
271: l_supply_uom varchar2(26);

Line 363: from mtl_supply

359: end if;
360:
361: select po_distribution_id
362: into l_distribution_id
363: from mtl_supply
364: where supply_type_code = 'SHIPMENT'
365: and po_line_location_id = l_line_location_id
366: and shipment_line_id = p_shipment_line_id;
367:

Line 374: update mtl_supply

370: 'l_distribution_id '||l_distribution_id );
371: end if;
372:
373: /* Update the shipment qty with the new quantity. */
374: update mtl_supply
375: set quantity = quantity + l_qty_shipped,
376: change_flag = 'Y'
377: where supply_type_code = 'SHIPMENT'
378: and po_line_location_id = l_line_location_id

Line 386: /* Update PO supply in mtl_supply */

382: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
383: 'After update to shipment supply' );
384: end if;
385:
386: /* Update PO supply in mtl_supply */
387: update mtl_supply
388: set quantity = quantity + l_qty_shipped,
389: change_flag = 'Y'
390: where supply_type_code = 'PO'

Line 387: update mtl_supply

383: 'After update to shipment supply' );
384: end if;
385:
386: /* Update PO supply in mtl_supply */
387: update mtl_supply
388: set quantity = quantity + l_qty_shipped,
389: change_flag = 'Y'
390: where supply_type_code = 'PO'
391: and po_distribution_id = l_distribution_id;

Line 431: delete from mtl_supply

427: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
428: 'Before Delete' );
429: end if;
430:
431: delete from mtl_supply
432: where rowid = l_supply_rowid;
433: IF (g_asn_debug = 'Y') THEN
434: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
435: 'After Delete' );

Line 475: 'Before update to mtl_supply.quantity' );

471: );
472:
473: IF (g_asn_debug = 'Y') THEN
474: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
475: 'Before update to mtl_supply.quantity' );
476: end if;
477: UPDATE MTL_SUPPLY
478: SET TO_ORG_PRIMARY_QUANTITY = l_primary_qty,
479: TO_ORG_PRIMARY_UOM = l_primary_uom,

Line 477: UPDATE MTL_SUPPLY

473: IF (g_asn_debug = 'Y') THEN
474: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
475: 'Before update to mtl_supply.quantity' );
476: end if;
477: UPDATE MTL_SUPPLY
478: SET TO_ORG_PRIMARY_QUANTITY = l_primary_qty,
479: TO_ORG_PRIMARY_UOM = l_primary_uom,
480: CHANGE_FLAG = NULL,
481: CHANGE_TYPE = null,

Line 491: 'After update to mtl_supply.quantity' );

487: WHERE ROWID = l_supply_rowid;
488:
489: IF (g_asn_debug = 'Y') THEN
490: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
491: 'After update to mtl_supply.quantity' );
492: end if;
493:
494:
495: end loop;