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.INV_LABEL_PVT2 dependencies on MTL_LOT_NUMBERS

Line 95: l_grade_code mtl_lot_numbers.grade_code%TYPE;

91:
92: ------------------------End of this change for Custom Labels project code--------------------
93:
94: -- added for conergence projact (invconv)
95: l_grade_code mtl_lot_numbers.grade_code%TYPE;
96: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE;
97: l_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE;
98: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE;
99: l_origination_type mtl_lot_numbers.origination_type%TYPE;

Line 96: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE;

92: ------------------------End of this change for Custom Labels project code--------------------
93:
94: -- added for conergence projact (invconv)
95: l_grade_code mtl_lot_numbers.grade_code%TYPE;
96: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE;
97: l_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE;
98: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE;
99: l_origination_type mtl_lot_numbers.origination_type%TYPE;
100: l_hold_date mtl_lot_numbers.hold_date%TYPE;

Line 97: l_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE;

93:
94: -- added for conergence projact (invconv)
95: l_grade_code mtl_lot_numbers.grade_code%TYPE;
96: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE;
97: l_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE;
98: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE;
99: l_origination_type mtl_lot_numbers.origination_type%TYPE;
100: l_hold_date mtl_lot_numbers.hold_date%TYPE;
101: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE;

Line 98: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE;

94: -- added for conergence projact (invconv)
95: l_grade_code mtl_lot_numbers.grade_code%TYPE;
96: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE;
97: l_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE;
98: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE;
99: l_origination_type mtl_lot_numbers.origination_type%TYPE;
100: l_hold_date mtl_lot_numbers.hold_date%TYPE;
101: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE;
102: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;

Line 99: l_origination_type mtl_lot_numbers.origination_type%TYPE;

95: l_grade_code mtl_lot_numbers.grade_code%TYPE;
96: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE;
97: l_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE;
98: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE;
99: l_origination_type mtl_lot_numbers.origination_type%TYPE;
100: l_hold_date mtl_lot_numbers.hold_date%TYPE;
101: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE;
102: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
103:

Line 100: l_hold_date mtl_lot_numbers.hold_date%TYPE;

96: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE;
97: l_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE;
98: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE;
99: l_origination_type mtl_lot_numbers.origination_type%TYPE;
100: l_hold_date mtl_lot_numbers.hold_date%TYPE;
101: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE;
102: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
103:
104: l_maturity_date mtl_lot_numbers.maturity_date%TYPE;

Line 101: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE;

97: l_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE;
98: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE;
99: l_origination_type mtl_lot_numbers.origination_type%TYPE;
100: l_hold_date mtl_lot_numbers.hold_date%TYPE;
101: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE;
102: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
103:
104: l_maturity_date mtl_lot_numbers.maturity_date%TYPE;
105: l_retest_date mtl_lot_numbers.retest_date%TYPE;

Line 102: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;

98: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE;
99: l_origination_type mtl_lot_numbers.origination_type%TYPE;
100: l_hold_date mtl_lot_numbers.hold_date%TYPE;
101: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE;
102: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
103:
104: l_maturity_date mtl_lot_numbers.maturity_date%TYPE;
105: l_retest_date mtl_lot_numbers.retest_date%TYPE;
106: l_origination_date mtl_lot_numbers.origination_date%TYPE;

Line 104: l_maturity_date mtl_lot_numbers.maturity_date%TYPE;

100: l_hold_date mtl_lot_numbers.hold_date%TYPE;
101: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE;
102: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
103:
104: l_maturity_date mtl_lot_numbers.maturity_date%TYPE;
105: l_retest_date mtl_lot_numbers.retest_date%TYPE;
106: l_origination_date mtl_lot_numbers.origination_date%TYPE;
107: l_lot_status mtl_material_statuses_vl.status_code%TYPE; -- Bug 4355080
108: -- invconv enf

Line 105: l_retest_date mtl_lot_numbers.retest_date%TYPE;

101: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE;
102: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
103:
104: l_maturity_date mtl_lot_numbers.maturity_date%TYPE;
105: l_retest_date mtl_lot_numbers.retest_date%TYPE;
106: l_origination_date mtl_lot_numbers.origination_date%TYPE;
107: l_lot_status mtl_material_statuses_vl.status_code%TYPE; -- Bug 4355080
108: -- invconv enf
109:

Line 106: l_origination_date mtl_lot_numbers.origination_date%TYPE;

102: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
103:
104: l_maturity_date mtl_lot_numbers.maturity_date%TYPE;
105: l_retest_date mtl_lot_numbers.retest_date%TYPE;
106: l_origination_date mtl_lot_numbers.origination_date%TYPE;
107: l_lot_status mtl_material_statuses_vl.status_code%TYPE; -- Bug 4355080
108: -- invconv enf
109:
110:

Line 888: FROM mtl_lot_numbers mln

884: , mln.width lot_width
885: , mln.width_uom lot_width_uom
886: , mln.curl_wrinkle_fold lot_curl
887: , mln.vendor_name lot_vendor
888: FROM mtl_lot_numbers mln
889: , mtl_material_statuses_vl mmsvl1
890: , mtl_parameters mp
891: , (SELECT msik.concatenated_segments item
892: , WMS_DEPLOY.GET_CLIENT_ITEM(l_organization_id, msik.inventory_item_id) client_item -- Added for LSP Project, bug 9087971

Line 1051: MTL_LOT_NUMBERS l,

1047: expiration_date,
1048: origination_date,
1049: sts.status_code
1050: FROM
1051: MTL_LOT_NUMBERS l,
1052: mtl_material_statuses_vl sts
1053: WHERE LOT_NUMBER = l_lot_number AND
1054: INVENTORY_ITEM_ID = l_inventory_item_id AND
1055: ORGANIZATION_ID = l_organization_id