DBA Data[Home] [Help]

APPS.GMI_QUANTITY_PUB dependencies on IC_TRAN_CMP

Line 39: , from_whse_code ic_tran_cmp.whse_code%TYPE

35: TYPE trans_rec_typ IS RECORD
36: ( trans_type NUMBER(2)
37: , item_no ic_item_mst.item_no%TYPE
38: , journal_no ic_jrnl_mst.journal_no%TYPE
39: , from_whse_code ic_tran_cmp.whse_code%TYPE
40: , to_whse_code ic_tran_cmp.whse_code%TYPE DEFAULT NULL
41: , item_um ic_item_mst.item_um%TYPE DEFAULT NULL
42: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
43: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL

Line 40: , to_whse_code ic_tran_cmp.whse_code%TYPE DEFAULT NULL

36: ( trans_type NUMBER(2)
37: , item_no ic_item_mst.item_no%TYPE
38: , journal_no ic_jrnl_mst.journal_no%TYPE
39: , from_whse_code ic_tran_cmp.whse_code%TYPE
40: , to_whse_code ic_tran_cmp.whse_code%TYPE DEFAULT NULL
41: , item_um ic_item_mst.item_um%TYPE DEFAULT NULL
42: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
43: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
44: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL

Line 45: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL

41: , item_um ic_item_mst.item_um%TYPE DEFAULT NULL
42: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
43: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
44: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
45: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
46: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
47: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL

Line 46: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL

42: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
43: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
44: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
45: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
46: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
47: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL

Line 47: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0

43: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
44: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
45: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
46: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
47: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE

Line 48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0

44: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
45: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
46: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
47: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE
52: , orgn_code ic_tran_cmp.orgn_code%TYPE

Line 49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL

45: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
46: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
47: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE
52: , orgn_code ic_tran_cmp.orgn_code%TYPE
53: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE

Line 50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL

46: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
47: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE
52: , orgn_code ic_tran_cmp.orgn_code%TYPE
53: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
54: , reason_code ic_tran_cmp.reason_code%TYPE

Line 51: , co_code ic_tran_cmp.co_code%TYPE

47: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE
52: , orgn_code ic_tran_cmp.orgn_code%TYPE
53: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
54: , reason_code ic_tran_cmp.reason_code%TYPE
55: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'

Line 52: , orgn_code ic_tran_cmp.orgn_code%TYPE

48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE
52: , orgn_code ic_tran_cmp.orgn_code%TYPE
53: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
54: , reason_code ic_tran_cmp.reason_code%TYPE
55: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
56: );

Line 53: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE

49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE
52: , orgn_code ic_tran_cmp.orgn_code%TYPE
53: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
54: , reason_code ic_tran_cmp.reason_code%TYPE
55: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
56: );
57: --

Line 54: , reason_code ic_tran_cmp.reason_code%TYPE

50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE
52: , orgn_code ic_tran_cmp.orgn_code%TYPE
53: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
54: , reason_code ic_tran_cmp.reason_code%TYPE
55: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
56: );
57: --
58: PROCEDURE Inventory_Posting