DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM_NEW dependencies on MTL_LOT_NUMBERS

Line 41: lot_number mtl_lot_numbers.lot_number%TYPE, --INVCONV

37: --lot_id ic_lots_mst.lot_id%TYPE, --INVCONV
38: --lot_no ic_lots_mst.lot_no%TYPE, --INVCONV
39: --lot_desc ic_lots_mst.lot_desc%TYPE, --INVCONV
40: --sublot_no ic_lots_mst.sublot_no%TYPE, --INVCONV
41: lot_number mtl_lot_numbers.lot_number%TYPE, --INVCONV
42: lot_description mtl_lot_numbers.description%TYPE, --INVCONV
43: order_qty1 oe_order_lines.ordered_quantity%TYPE,
44: order_qty2 oe_order_lines.ordered_quantity2%TYPE,
45: order_uom1 oe_order_lines.order_quantity_uom%TYPE, --INVCONV

Line 42: lot_description mtl_lot_numbers.description%TYPE, --INVCONV

38: --lot_no ic_lots_mst.lot_no%TYPE, --INVCONV
39: --lot_desc ic_lots_mst.lot_desc%TYPE, --INVCONV
40: --sublot_no ic_lots_mst.sublot_no%TYPE, --INVCONV
41: lot_number mtl_lot_numbers.lot_number%TYPE, --INVCONV
42: lot_description mtl_lot_numbers.description%TYPE, --INVCONV
43: order_qty1 oe_order_lines.ordered_quantity%TYPE,
44: order_qty2 oe_order_lines.ordered_quantity2%TYPE,
45: order_uom1 oe_order_lines.order_quantity_uom%TYPE, --INVCONV
46: order_uom2 oe_order_lines.ordered_quantity_UOM2%TYPE, --INVCONV

Line 97: lot_number mtl_lot_numbers.lot_number%TYPE, --INVCONV

93: --location ic_loct_mst.whse_code%TYPE, --INVCONV
94: locator_id NUMBER, --INVCONV
95: --lot_id ic_lots_mst.lot_id%TYPE, --INVCONV
96: --lot_no ic_lots_mst.lot_no%TYPE, --INVCONV
97: lot_number mtl_lot_numbers.lot_number%TYPE, --INVCONV
98: org_id oe_order_headers_all.org_id%TYPE,
99: sampling_event_id gmd_sampling_events.sampling_event_id%TYPE,
100: spec_id gmd_specifications_b.spec_id%TYPE,
101: ship_to_site_id hz_cust_site_uses_all.site_use_id%TYPE -- Bug# 5399406

Line 109: ,lot_number mtl_lot_numbers.lot_number%TYPE --IN --INVCONV

105: ( inventory_item_id NUMBER -- IN
106: ,revision NUMBER --Bug# 4662469
107: --,lot_id NUMBER -- IN --INVCONV
108: --,lot_no VARCHAR2(32) -- IN --INVCONV
109: ,lot_number mtl_lot_numbers.lot_number%TYPE --IN --INVCONV
110: --,whse_code VARCHAR2(4) -- IN --INVCONV
111: ,subinventory mtl_secondary_inventories.secondary_inventory_name%TYPE --IN --INVCONV
112: --,location VARCHAR2(16) -- IN --INVCONV
113: ,locator_id NUMBER --IN --INVCONV