eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DELIVERY_DETAILS_INV dependencies on MTL_SYSTEM_ITEMS

Line 56: TYPE mtl_system_items_rec IS RECORD

52: transactable_flag VARCHAR2(1) -- Bug 3599363
53: );
54:
55: -- HW OPMCONV - Item attributes
56: TYPE mtl_system_items_rec IS RECORD
57: ( primary_uom_code mtl_system_items.primary_uom_code%TYPE
58: , secondary_uom_code mtl_system_items.secondary_uom_code%TYPE
59: , secondary_default_ind mtl_system_items.secondary_default_ind%TYPE
60: , lot_control_code mtl_system_items.lot_control_code%TYPE

Line 57: ( primary_uom_code mtl_system_items.primary_uom_code%TYPE

53: );
54:
55: -- HW OPMCONV - Item attributes
56: TYPE mtl_system_items_rec IS RECORD
57: ( primary_uom_code mtl_system_items.primary_uom_code%TYPE
58: , secondary_uom_code mtl_system_items.secondary_uom_code%TYPE
59: , secondary_default_ind mtl_system_items.secondary_default_ind%TYPE
60: , lot_control_code mtl_system_items.lot_control_code%TYPE
61: , tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE

Line 58: , secondary_uom_code mtl_system_items.secondary_uom_code%TYPE

54:
55: -- HW OPMCONV - Item attributes
56: TYPE mtl_system_items_rec IS RECORD
57: ( primary_uom_code mtl_system_items.primary_uom_code%TYPE
58: , secondary_uom_code mtl_system_items.secondary_uom_code%TYPE
59: , secondary_default_ind mtl_system_items.secondary_default_ind%TYPE
60: , lot_control_code mtl_system_items.lot_control_code%TYPE
61: , tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE
62: , dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE

Line 59: , secondary_default_ind mtl_system_items.secondary_default_ind%TYPE

55: -- HW OPMCONV - Item attributes
56: TYPE mtl_system_items_rec IS RECORD
57: ( primary_uom_code mtl_system_items.primary_uom_code%TYPE
58: , secondary_uom_code mtl_system_items.secondary_uom_code%TYPE
59: , secondary_default_ind mtl_system_items.secondary_default_ind%TYPE
60: , lot_control_code mtl_system_items.lot_control_code%TYPE
61: , tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE
62: , dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE
63: , dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE

Line 60: , lot_control_code mtl_system_items.lot_control_code%TYPE

56: TYPE mtl_system_items_rec IS RECORD
57: ( primary_uom_code mtl_system_items.primary_uom_code%TYPE
58: , secondary_uom_code mtl_system_items.secondary_uom_code%TYPE
59: , secondary_default_ind mtl_system_items.secondary_default_ind%TYPE
60: , lot_control_code mtl_system_items.lot_control_code%TYPE
61: , tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE
62: , dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE
63: , dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE
64: , enabled_flag mtl_system_items.enabled_flag%TYPE

Line 61: , tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE

57: ( primary_uom_code mtl_system_items.primary_uom_code%TYPE
58: , secondary_uom_code mtl_system_items.secondary_uom_code%TYPE
59: , secondary_default_ind mtl_system_items.secondary_default_ind%TYPE
60: , lot_control_code mtl_system_items.lot_control_code%TYPE
61: , tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE
62: , dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE
63: , dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE
64: , enabled_flag mtl_system_items.enabled_flag%TYPE
65: , shippable_item_flag mtl_system_items.shippable_item_flag%TYPE

Line 62: , dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE

58: , secondary_uom_code mtl_system_items.secondary_uom_code%TYPE
59: , secondary_default_ind mtl_system_items.secondary_default_ind%TYPE
60: , lot_control_code mtl_system_items.lot_control_code%TYPE
61: , tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE
62: , dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE
63: , dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE
64: , enabled_flag mtl_system_items.enabled_flag%TYPE
65: , shippable_item_flag mtl_system_items.shippable_item_flag%TYPE
66: , inventory_item_flag mtl_system_items.inventory_item_flag%TYPE

Line 63: , dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE

59: , secondary_default_ind mtl_system_items.secondary_default_ind%TYPE
60: , lot_control_code mtl_system_items.lot_control_code%TYPE
61: , tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE
62: , dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE
63: , dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE
64: , enabled_flag mtl_system_items.enabled_flag%TYPE
65: , shippable_item_flag mtl_system_items.shippable_item_flag%TYPE
66: , inventory_item_flag mtl_system_items.inventory_item_flag%TYPE
67: , lot_divisible_flag mtl_system_items.lot_divisible_flag%TYPE

Line 64: , enabled_flag mtl_system_items.enabled_flag%TYPE

60: , lot_control_code mtl_system_items.lot_control_code%TYPE
61: , tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE
62: , dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE
63: , dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE
64: , enabled_flag mtl_system_items.enabled_flag%TYPE
65: , shippable_item_flag mtl_system_items.shippable_item_flag%TYPE
66: , inventory_item_flag mtl_system_items.inventory_item_flag%TYPE
67: , lot_divisible_flag mtl_system_items.lot_divisible_flag%TYPE
68: , lot_status_enabled mtl_system_items.lot_status_enabled%TYPE

Line 65: , shippable_item_flag mtl_system_items.shippable_item_flag%TYPE

61: , tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE
62: , dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE
63: , dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE
64: , enabled_flag mtl_system_items.enabled_flag%TYPE
65: , shippable_item_flag mtl_system_items.shippable_item_flag%TYPE
66: , inventory_item_flag mtl_system_items.inventory_item_flag%TYPE
67: , lot_divisible_flag mtl_system_items.lot_divisible_flag%TYPE
68: , lot_status_enabled mtl_system_items.lot_status_enabled%TYPE
69: -- bug 5264874 Added two new attributes

Line 66: , inventory_item_flag mtl_system_items.inventory_item_flag%TYPE

62: , dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE
63: , dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE
64: , enabled_flag mtl_system_items.enabled_flag%TYPE
65: , shippable_item_flag mtl_system_items.shippable_item_flag%TYPE
66: , inventory_item_flag mtl_system_items.inventory_item_flag%TYPE
67: , lot_divisible_flag mtl_system_items.lot_divisible_flag%TYPE
68: , lot_status_enabled mtl_system_items.lot_status_enabled%TYPE
69: -- bug 5264874 Added two new attributes
70: , reservable_type mtl_system_items.reservable_type%TYPE

Line 67: , lot_divisible_flag mtl_system_items.lot_divisible_flag%TYPE

63: , dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE
64: , enabled_flag mtl_system_items.enabled_flag%TYPE
65: , shippable_item_flag mtl_system_items.shippable_item_flag%TYPE
66: , inventory_item_flag mtl_system_items.inventory_item_flag%TYPE
67: , lot_divisible_flag mtl_system_items.lot_divisible_flag%TYPE
68: , lot_status_enabled mtl_system_items.lot_status_enabled%TYPE
69: -- bug 5264874 Added two new attributes
70: , reservable_type mtl_system_items.reservable_type%TYPE
71: , mtl_transactions_enabled_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE

Line 68: , lot_status_enabled mtl_system_items.lot_status_enabled%TYPE

64: , enabled_flag mtl_system_items.enabled_flag%TYPE
65: , shippable_item_flag mtl_system_items.shippable_item_flag%TYPE
66: , inventory_item_flag mtl_system_items.inventory_item_flag%TYPE
67: , lot_divisible_flag mtl_system_items.lot_divisible_flag%TYPE
68: , lot_status_enabled mtl_system_items.lot_status_enabled%TYPE
69: -- bug 5264874 Added two new attributes
70: , reservable_type mtl_system_items.reservable_type%TYPE
71: , mtl_transactions_enabled_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE
72: , container_item_flag mtl_system_items.container_item_flag%TYPE);

Line 70: , reservable_type mtl_system_items.reservable_type%TYPE

66: , inventory_item_flag mtl_system_items.inventory_item_flag%TYPE
67: , lot_divisible_flag mtl_system_items.lot_divisible_flag%TYPE
68: , lot_status_enabled mtl_system_items.lot_status_enabled%TYPE
69: -- bug 5264874 Added two new attributes
70: , reservable_type mtl_system_items.reservable_type%TYPE
71: , mtl_transactions_enabled_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE
72: , container_item_flag mtl_system_items.container_item_flag%TYPE);
73:
74: -- bug 5264874

Line 71: , mtl_transactions_enabled_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE

67: , lot_divisible_flag mtl_system_items.lot_divisible_flag%TYPE
68: , lot_status_enabled mtl_system_items.lot_status_enabled%TYPE
69: -- bug 5264874 Added two new attributes
70: , reservable_type mtl_system_items.reservable_type%TYPE
71: , mtl_transactions_enabled_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE
72: , container_item_flag mtl_system_items.container_item_flag%TYPE);
73:
74: -- bug 5264874
75: TYPE mtl_org_param_rec IS RECORD

Line 72: , container_item_flag mtl_system_items.container_item_flag%TYPE);

68: , lot_status_enabled mtl_system_items.lot_status_enabled%TYPE
69: -- bug 5264874 Added two new attributes
70: , reservable_type mtl_system_items.reservable_type%TYPE
71: , mtl_transactions_enabled_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE
72: , container_item_flag mtl_system_items.container_item_flag%TYPE);
73:
74: -- bug 5264874
75: TYPE mtl_org_param_rec IS RECORD
76: ( stock_locator_control_code mtl_parameters.stock_locator_control_code%type

Line 101: fetches the control codes/flags from mtl_system_items for the

97: x_return_status - return status of the API.
98: DESCRIPTION : This procedure takes a delivery detail id or alternatively the
99: inventory item id and organization id and determines whether
100: the item is under any of the inventory controls. The API
101: fetches the control codes/flags from mtl_system_items for the
102: given inventory item and organization and decodes them and
103: returns a record of inv controls with a 'Y' or a 'N' for each
104: of the inv controls.
105:

Line 584: x_mtl_system_items_rec - Record to hold item informatiom

580: -----------------------------------------------------------------------------
581: PROCEDURE : Get_item_information
582: PARAMETERS : p_organization_id - organization id
583: p_inventory_item_id - source system code
584: x_mtl_system_items_rec - Record to hold item informatiom
585: x_return_status - success if able to look up item information
586: error if cannot find item information
587:
588: DESCRIPTION : This API takes the organization and inventory item

Line 597: , x_mtl_system_items_rec OUT NOCOPY WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec

593: */
594: PROCEDURE Get_item_information (
595: p_organization_id IN NUMBER
596: , p_inventory_item_id IN NUMBER
597: , x_mtl_system_items_rec OUT NOCOPY WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec
598: , x_return_status OUT NOCOPY VARCHAR2
599: );
600:
601: