DBA Data[Home] [Help]

APPS.INVUPD2B dependencies on INVIDIT3

Line 3887: Intimate INVIDIT3.Table_Queries about change of stockable flag.

3883: When on-hand stock exist and we are trying to change stockable flag IOI should error out.
3884: But to log error condition checked is
3885: if ((msi_temp.STOCK_ENABLED_FLAG <> msii_temp.STOCK_ENABLED_FLAG) AND (stockable = 1) AND msii_temp.STOCK_ENABLED_FLAG = 'N') THEN
3886: ----log error -----
3887: Intimate INVIDIT3.Table_Queries about change of stockable flag.
3888: INVIDIT3.Table_Queries will set stockable = 1 when on-hand stock exists.
3889: to now more look into update *** GNOOKALA 10/09/12 11:54 am *** in bug 14555362. */
3890:
3891: IF msi_temp.STOCK_ENABLED_FLAG <> msii_temp.STOCK_ENABLED_FLAG THEN

Line 3888: INVIDIT3.Table_Queries will set stockable = 1 when on-hand stock exists.

3884: But to log error condition checked is
3885: if ((msi_temp.STOCK_ENABLED_FLAG <> msii_temp.STOCK_ENABLED_FLAG) AND (stockable = 1) AND msii_temp.STOCK_ENABLED_FLAG = 'N') THEN
3886: ----log error -----
3887: Intimate INVIDIT3.Table_Queries about change of stockable flag.
3888: INVIDIT3.Table_Queries will set stockable = 1 when on-hand stock exists.
3889: to now more look into update *** GNOOKALA 10/09/12 11:54 am *** in bug 14555362. */
3890:
3891: IF msi_temp.STOCK_ENABLED_FLAG <> msii_temp.STOCK_ENABLED_FLAG THEN
3892: stockable:=0;

Line 3898: INVIDIT3.Table_Queries(

3894: stockable:=NULL;
3895: END IF;
3896: /* end bug 15940041 */
3897:
3898: INVIDIT3.Table_Queries(
3899: p_org_id => msii_temp.organization_id,
3900: p_item_id => msii_temp.inventory_item_id,
3901: p_master_org => morgid,
3902: p_primary_uom_code => msii_temp.primary_uom_code,