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 1012: nvl(mrp_bic.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL),

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

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

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

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

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

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

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