APPS.MRP_KANBAN_SNAPSHOT_PK dependencies on WIP_CONSTANTS

Line 804: /* Basis type of 1 = WIP_CONSTANTS.ITEM_BASED_MTL */

800: 'mrp_bic.planning_factor,' ||
801: 'mrp_bic.item_num,' ||
802: /* End of Update */
803: /* Modified for lot based material support. Adding query of basis_type and wip_supply_type */
804: /* Basis type of 1 = WIP_CONSTANTS.ITEM_BASED_MTL */
805: 'nvl(mrp_bic.basis_type,1),' ||
806: /* Supply type of 1 = WIP_CONSTANTS.PUSH */
807: 'nvl(mrp_bic.wip_supply_type,1),' ||
808: 'bbom.alternate_bom_designator,' ||

Line 806: /* Supply type of 1 = WIP_CONSTANTS.PUSH */

802: /* End of Update */
803: /* Modified for lot based material support. Adding query of basis_type and wip_supply_type */
804: /* Basis type of 1 = WIP_CONSTANTS.ITEM_BASED_MTL */
805: 'nvl(mrp_bic.basis_type,1),' ||
806: /* Supply type of 1 = WIP_CONSTANTS.PUSH */
807: 'nvl(mrp_bic.wip_supply_type,1),' ||
808: 'bbom.alternate_bom_designator,' ||
809: l_quote || 'Y' || l_quote || ',' ||
810: 'mic.category_id,' ||

Line 1011: nvl(mrp_bic.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL),

1007: mrp_bic.planning_factor,
1008: mrp_bic.item_num,
1009: /* End of Update */
1010: /* Modified for lot based material support. Adding query of basis_type and wip_supply_type */
1011: nvl(mrp_bic.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL),
1012: nvl(mrp_bic.wip_supply_type,WIP_CONSTANTS.PUSH),
1013: bbom.alternate_bom_designator,
1014: l_level_count + 1,
1015: NULL, -- set it to NULL and update it next stmt

Line 1012: nvl(mrp_bic.wip_supply_type,WIP_CONSTANTS.PUSH),

1008: mrp_bic.item_num,
1009: /* End of Update */
1010: /* Modified for lot based material support. Adding query of basis_type and wip_supply_type */
1011: nvl(mrp_bic.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL),
1012: nvl(mrp_bic.wip_supply_type,WIP_CONSTANTS.PUSH),
1013: bbom.alternate_bom_designator,
1014: l_level_count + 1,
1015: NULL, -- set it to NULL and update it next stmt
1016: mic.category_id,

Line 1128: nvl(mrp_bic.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL),

1124: mrp_bic.planning_factor,
1125: mrp_bic.item_num,
1126: /* End of Update */
1127: /* Modified for lot based material support. Adding query of basis_type and wip_supply_type */
1128: nvl(mrp_bic.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL),
1129: nvl(mrp_bic.wip_supply_type,WIP_CONSTANTS.PUSH),
1130: bbom.alternate_bom_designator,
1131: l_level_count + 1,
1132: NULL, -- set it to NULL and update it next stmt

Line 1129: nvl(mrp_bic.wip_supply_type,WIP_CONSTANTS.PUSH),

1125: mrp_bic.item_num,
1126: /* End of Update */
1127: /* Modified for lot based material support. Adding query of basis_type and wip_supply_type */
1128: nvl(mrp_bic.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL),
1129: nvl(mrp_bic.wip_supply_type,WIP_CONSTANTS.PUSH),
1130: bbom.alternate_bom_designator,
1131: l_level_count + 1,
1132: NULL, -- set it to NULL and update it next stmt
1133: mic.category_id,