DBA Data[Home] [Help]

APPS.CSI_PROCESS_TXN_PVT dependencies on MTL_SYSTEM_ITEMS

Line 406: l_serial_code mtl_system_items.serial_number_control_code%TYPE;

402: IS
403:
404: l_item_attr_rec csi_process_txn_pvt.item_attr_rec;
405:
406: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
407: l_lot_code mtl_system_items.lot_control_code%TYPE;
408: l_locator_code mtl_system_items.location_control_code%TYPE;
409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;

Line 407: l_lot_code mtl_system_items.lot_control_code%TYPE;

403:
404: l_item_attr_rec csi_process_txn_pvt.item_attr_rec;
405:
406: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
407: l_lot_code mtl_system_items.lot_control_code%TYPE;
408: l_locator_code mtl_system_items.location_control_code%TYPE;
409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;

Line 408: l_locator_code mtl_system_items.location_control_code%TYPE;

404: l_item_attr_rec csi_process_txn_pvt.item_attr_rec;
405:
406: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
407: l_lot_code mtl_system_items.lot_control_code%TYPE;
408: l_locator_code mtl_system_items.location_control_code%TYPE;
409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
412: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;

Line 409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;

405:
406: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
407: l_lot_code mtl_system_items.lot_control_code%TYPE;
408: l_locator_code mtl_system_items.location_control_code%TYPE;
409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
412: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
413: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;

Line 410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;

406: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
407: l_lot_code mtl_system_items.lot_control_code%TYPE;
408: l_locator_code mtl_system_items.location_control_code%TYPE;
409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
412: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
413: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
414: l_bom_item_type mtl_system_items.bom_item_type%TYPE;

Line 411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;

407: l_lot_code mtl_system_items.lot_control_code%TYPE;
408: l_locator_code mtl_system_items.location_control_code%TYPE;
409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
412: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
413: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
414: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
415:

Line 412: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;

408: l_locator_code mtl_system_items.location_control_code%TYPE;
409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
412: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
413: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
414: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
415:
416: BEGIN

Line 413: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;

409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
412: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
413: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
414: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
415:
416: BEGIN
417:

Line 414: l_bom_item_type mtl_system_items.bom_item_type%TYPE;

410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
412: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
413: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
414: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
415:
416: BEGIN
417:
418: csi_t_gen_utility_pvt.dump_api_info(

Line 444: FROM mtl_system_items_kfv

440: l_shippable_flag,
441: l_inv_item_flag,
442: l_stockable_flag,
443: l_bom_item_type
444: FROM mtl_system_items_kfv
445: WHERE inventory_item_id = p_inventory_item_id
446: AND organization_id = p_organization_id;
447:
448: EXCEPTION