APPS.GMICVAL dependencies on IC_ITEM_MST

Line 161: as found in ic_item_mst.

157:
158: plocation - location to be validated
159: pwhse_code - warehouse where the location resides.
160: ploct_ctl - the items loction control indicator
161: as found in ic_item_mst.
162:
163: RETURNS:
164: 0 Success
165: -62 Location is not valid.

Line 241: FROM ic_item_mst

237: /* Cursor Definitions
238: ==================*/
239: CURSOR validate_item IS
240: SELECT item_no
241: FROM ic_item_mst
242: WHERE item_id = pitem_id
243: AND delete_mark = 0;
244:
245: /* Local variables.

Line 247: l_item_no ic_item_mst.item_no%TYPE;

243: AND delete_mark = 0;
244:
245: /* Local variables.
246: ================*/
247: l_item_no ic_item_mst.item_no%TYPE;
248:
249: /* ================================================*/
250: BEGIN
251:

Line 307: FROM ic_item_mst

303: /* Cursor Definitions
304: ==================*/
305: CURSOR validate_item IS
306: SELECT item_id
307: FROM ic_item_mst
308: WHERE item_no = UPPER(pitem_no)
309: AND delete_mark = 0;
310:
311: /* Local variables.

Line 914: l_item_id ic_item_mst.item_id%TYPE;

910: RETURN NUMBER IS
911:
912: /* Local variables.
913: ================ */
914: l_item_id ic_item_mst.item_id%TYPE;
915: l_lot_ctl ic_item_mst.lot_ctl%TYPE;
916: l_sublot_ctl ic_item_mst.sublot_ctl%TYPE;
917: l_lot_id ic_lots_mst.lot_id%TYPE;
918:

Line 915: l_lot_ctl ic_item_mst.lot_ctl%TYPE;

911:
912: /* Local variables.
913: ================ */
914: l_item_id ic_item_mst.item_id%TYPE;
915: l_lot_ctl ic_item_mst.lot_ctl%TYPE;
916: l_sublot_ctl ic_item_mst.sublot_ctl%TYPE;
917: l_lot_id ic_lots_mst.lot_id%TYPE;
918:
919:

Line 916: l_sublot_ctl ic_item_mst.sublot_ctl%TYPE;

912: /* Local variables.
913: ================ */
914: l_item_id ic_item_mst.item_id%TYPE;
915: l_lot_ctl ic_item_mst.lot_ctl%TYPE;
916: l_sublot_ctl ic_item_mst.sublot_ctl%TYPE;
917: l_lot_id ic_lots_mst.lot_id%TYPE;
918:
919:
920: CURSOR get_item_attributes IS

Line 922: FROM ic_item_mst

918:
919:
920: CURSOR get_item_attributes IS
921: SELECT item_id, lot_ctl, sublot_ctl
922: FROM ic_item_mst
923: WHERE item_no = UPPER(pitem_no)
924: AND delete_mark = 0;
925:
926: CURSOR validate_lot IS

Line 1058: l_item_id ic_item_mst.item_id%TYPE;

1054: RETURN NUMBER IS
1055:
1056: /* Local variables.
1057: ================ */
1058: l_item_id ic_item_mst.item_id%TYPE;
1059: l_lot_ctl ic_item_mst.lot_ctl%TYPE;
1060: l_sublot_ctl ic_item_mst.sublot_ctl%TYPE;
1061: l_lot_id ic_lots_mst.lot_id%TYPE;
1062: /* Cursor Definitions

Line 1059: l_lot_ctl ic_item_mst.lot_ctl%TYPE;

1055:
1056: /* Local variables.
1057: ================ */
1058: l_item_id ic_item_mst.item_id%TYPE;
1059: l_lot_ctl ic_item_mst.lot_ctl%TYPE;
1060: l_sublot_ctl ic_item_mst.sublot_ctl%TYPE;
1061: l_lot_id ic_lots_mst.lot_id%TYPE;
1062: /* Cursor Definitions
1063:

Line 1060: l_sublot_ctl ic_item_mst.sublot_ctl%TYPE;

1056: /* Local variables.
1057: ================ */
1058: l_item_id ic_item_mst.item_id%TYPE;
1059: l_lot_ctl ic_item_mst.lot_ctl%TYPE;
1060: l_sublot_ctl ic_item_mst.sublot_ctl%TYPE;
1061: l_lot_id ic_lots_mst.lot_id%TYPE;
1062: /* Cursor Definitions
1063:
1064:

Line 1068: FROM ic_item_mst

1064:
1065: ================== */
1066: CURSOR get_item_attributes IS
1067: SELECT item_id, lot_ctl, sublot_ctl
1068: FROM ic_item_mst
1069: WHERE item_no = UPPER(pitem_id)
1070: AND delete_mark = 0;
1071:
1072: CURSOR validate_lot IS

Line 1342: as defined by the item in the ic_item_mst table.

1338:
1339: The purpose of the function is to validate
1340: that the secondary quantity is within the
1341: standard deviation high and low for an item
1342: as defined by the item in the ic_item_mst table.
1343:
1344: PARAMETERS:
1345: pitem_id The surrogate key of the item number
1346:

Line 1516: FROM ic_item_mst

1512: /* Cursor Definitions
1513: ================== */
1514: CURSOR item_uom_attr IS
1515: SELECT dualum_ind
1516: FROM ic_item_mst
1517: WHERE item_id = pitem_id
1518: AND delete_mark = 0;
1519:
1520: BEGIN

Line 1600: FROM ic_item_mst

1596: /* Cursor Definitions
1597: ================== */
1598: CURSOR item_uom_attr IS
1599: SELECT deviation_hi, deviation_lo
1600: FROM ic_item_mst
1601: WHERE item_id = pitem_id
1602: AND delete_mark = 0;
1603:
1604: BEGIN